Opening a form with no data

jevans

Registered User.
Local time
Today, 20:21
Joined
Oct 11, 2000
Messages
23
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.
 

Users who are viewing this thread

Back
Top Bottom