J
Jaybird
The syntax of these subform control references always gets me...
I would like the value of txtCreditMemo on subform ChildsbfInvoice to be
zero if the sum of txtLINTOTL on subform qryLINPLAT is less than zero. I've
tried all kinds of things but my code is currently this:
Private Sub Form_Current()
Dim MyVariable As Variant
MyVariable = Sum(Me.Parent.qryLINPLAT.Form.txtLineTotal)
If MyVariable < 0 Then Me.txtCreditMemo = 0
If MyVariable >= 0 Then Me.txtCreditMemo = 1
End Sub
I would like the value of txtCreditMemo on subform ChildsbfInvoice to be
zero if the sum of txtLINTOTL on subform qryLINPLAT is less than zero. I've
tried all kinds of things but my code is currently this:
Private Sub Form_Current()
Dim MyVariable As Variant
MyVariable = Sum(Me.Parent.qryLINPLAT.Form.txtLineTotal)
If MyVariable < 0 Then Me.txtCreditMemo = 0
If MyVariable >= 0 Then Me.txtCreditMemo = 1
End Sub