I have this code in the on current event of a main form
I want a checkbox on the subform to change the value to false if QtyAvail = 0
But it is not updating.
I want a checkbox on the subform to change the value to false if QtyAvail = 0
But it is not updating.
Code:
Private Sub Form_Current()
If Me!frmOrderDetailsListToMarkForCompletionWthQty.Form!QtyAvail = 0 Then
Me!frmOrderDetailsListToMarkForCompletionWthQty.Form!chkIsComplete = True
Else
Me!frmOrderDetailsListToMarkForCompletionWthQty.Form!chkIsComplete = False
End If
End Sub