I have created a macro that is designed to ensure that users cannot continue until the field has been completed (combo box). There are three conditions and actions:
[Field_Name] Is Null > MsgBox
[Field_Name] Is Null > GoToControl (same field)
[Field_Name] Is Null > CancelEvent
This prevents the user from exiting this field until their name is chosen from a drop-down box.
This has been working fine until I added criteria to the query on which the form is based. I needed to pull only records within certain zip codes.
As soon as I added that filter to the query, the macro no longer works and the users can exit that field and leave it blank. If I remove the criteria from the query, the macro works again and the user must enter their name.
Any ideas on why this is the case and how I can correct it?
Thank you for any help - I am not a programmer!
[Field_Name] Is Null > MsgBox
[Field_Name] Is Null > GoToControl (same field)
[Field_Name] Is Null > CancelEvent
This prevents the user from exiting this field until their name is chosen from a drop-down box.
This has been working fine until I added criteria to the query on which the form is based. I needed to pull only records within certain zip codes.
As soon as I added that filter to the query, the macro no longer works and the users can exit that field and leave it blank. If I remove the criteria from the query, the macro works again and the user must enter their name.
Any ideas on why this is the case and how I can correct it?
Thank you for any help - I am not a programmer!