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 ?