I have 2 tables Customers and Contracts. Each table has its own form. In the Customer Form I have the Customer # field code to open the Contracts Form when this field is double clicked on. When there's no contract data the Debugging window pops up. How can I get a MSG box to appear and say "No contracts for this Customer"?

Thank you,

Check the recordcount. If it's zero add your message.