(i posted this on another thread but then thought it might be better answered here - i apologize if this causes a problem)
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 > 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 users 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!
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 > 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 users 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!