I THINK this should be easy... but...
Have a form with a subform.
The Form references a customer, the subform references a location (Customers could have more than one location).
Users were doing things to create blank records, so I set the state field on the location address to NOT NULL (SQL Backend). Now, when adding a new customer, it's automatically trying to add a location.
I need to either:
Stop the creation of a new Location automatically when creating a new customer (no clue how to do that).
When someone clicks on the New Account button (Macro based, not Code based) how I can have the Macro based button automatically set the state value so as not to cause an error to pop up about NULLs.
Your assistance would be greatly appreciated!