Drawing a blank on the best place to but the code to check the value of certain field.
the field is on 1 of many subforms of a main form (tabs). I have tried it on Load of subform, ONcurrent etc. the code does not seem to check the value of the field. any ideas.
If IsNull(Forms![frmProformaInv]![chdProformaWO].Form![PricePerUnit1]) Or _
Forms![frmProformaInv]![chdProformaWO].Form![PricePerUnit1] = 0 Then
MsgBox("The Unit Price currently is missing or contains a Zero value. Please review and enter the correct value.", _
vbExclamation, "Unit Price Is Not Validate")
Me.PricePerUnit.Enabled = True