StampIT
asked on
Handling zero records situation
In MS Access there is a main form with a sub form. They are linked by a common customer field. The issue is when the source query of the main form has no records for the particular customer chosen. An empty form results. How would I set this up so that when the main form source query has no records for a customer a message box advising the user that this customer has no records appears and then close the form ?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
You are welcome!
ASKER