Hi, What I am attempting to do is have the buttons (Auto) (Home) disabled until the Cust ID is entered. (screen shots attached in attempt to make my words clearer!)
Even though the Cust ID is a required field I don’t get the error message until after the Auto button is clicked and it takes the user to the Auto Policies Page (see attached). Unfortunately, I am already using an autonumber field.
I have a Client form (see attached) with only client and family info. The Enter Auto and Enter Home buttons were created using macro Wizards. Each button goes to another form and sets different fields (see attached)
When the Enter Auto or Enter Home buttons are clicked, we are taken to the respective pages and importing the insured name (by Concatenation) and below that the Cust ID. If the Cust ID isn’t entered on the Clients page it doesn’t appear on any other pages and cannot be saved.
So, in a nutshell, I don’t want to leave the Client page until the all the required information is inputted, and maybe have my own Error Message. This database has evolved over the last 15 years. Had I known better everything would have been done with VBA.
Any suggestions would be greatly appreciated!
Frank