jsgs
Instructor
- Aug 22, 2008
- 47
Problem is about a boat rental system.
I have a main form for customers, frmCustomer. It contains a subform, fSubRental, to record rental transactions of the customer.
To record a rental, I choose the customer from main form, then I enter his rental details (boat, time out, etc.) on the subform.
What I would like to do is to prevent the recording of a rental for a customer who has already loaned a boat and has not yet returned it. I would like a message to be displayed the moment the user tries to enter the boat name for the selected customer.
Thanks in advance for your help.
I have a main form for customers, frmCustomer. It contains a subform, fSubRental, to record rental transactions of the customer.
To record a rental, I choose the customer from main form, then I enter his rental details (boat, time out, etc.) on the subform.
What I would like to do is to prevent the recording of a rental for a customer who has already loaned a boat and has not yet returned it. I would like a message to be displayed the moment the user tries to enter the boat name for the selected customer.
Thanks in advance for your help.