G
Guest
Hello All,
I have a main form and sub-form. After selecting an employee on the
main form, the sub-form will display all matching records. If there are no
matching records, the subform will prefill with the ID from the main form and
start the 1st record for the employee.
I wanted to put data validation on the before update event, however
the warning message fires as soon as the form is pre-filled for new records.
I only want the messages to fire when the navigation buttons are used.
I am using the default navigation buttons, because I want to keep the
"1 of 3" feature.
Any suggestions would be greatly appreciated!
Thank you in advance,
Renee
I have a main form and sub-form. After selecting an employee on the
main form, the sub-form will display all matching records. If there are no
matching records, the subform will prefill with the ID from the main form and
start the 1st record for the employee.
I wanted to put data validation on the before update event, however
the warning message fires as soon as the form is pre-filled for new records.
I only want the messages to fire when the navigation buttons are used.
I am using the default navigation buttons, because I want to keep the
"1 of 3" feature.
Any suggestions would be greatly appreciated!
Thank you in advance,
Renee