|
是的,我已建好,代码是少了很多只用这个就可以了
Dim pr As Currency
Dim pr2 As Currency
Me.单价 = Nz(DLookup(Me.工序名称, "产品表查询", "[产品编号]=" & 产品编号.Value), 0)
If [单据类型] = "CH" Then
If Me.样品单 = True Then
pr = Nz(DLookup(Me.工序名称, "产品表查询", "[产品编号]=" & 产品编号.Value), 0)
pr2 = Nz(DLookup("彩绘单价", "产品表查询", "[产品编号]=" & 产品编号.Value), 0)
If Me.部门 = 8 Then
Me.单价2 = pr2 * DLookup("倍数", "样品计件参数", "[上区间]<= " & Me.订单量 & " And [下区间]>=" & Me.订单量 & " And [部门] = " & Me.部门 & "")
Else
Me.单价2 = pr * DLookup("倍数", "样品计件参数", "[上区间]<= " & Me.订单量 & " And [下区间]>=" & Me.订单量 & " And [部门] = " & Me.部门 & "")
End If
End If
End If
但更新单价不能一次完成,须手工一个一个更新。不会用记录集。
现在是放在单价2的获得焦点事件中,如果用一个按钮点一下就好了 |
|