Move between 2 forms

jbphoenix

Registered User.
Local time
Today, 13:29
Joined
Jan 25, 2007
Messages
98
I have a form with customer info and a subform with details. I need certain fields to be filled in by the user before they can proceed to the subform. How do I set something up that will notify the user if a field is left blank on the main form?
 
in the on enter of the subform u can put
if (isNull [main form fieldName] or [main form fieldName] = "") Then
MsgBox "u must fill out all fields in main form"
[main form fieldName].setfocus
Else
End if
 

Users who are viewing this thread

Back
Top Bottom