Hi all,
I am currently trying to program a video hire form for HNC Project. The form loads from two querries: the main form from 'Customers' table; the subform from 'Rental records 'table. The form loads fine with the main menu scroll bars running through the records.....but I need the form to load with blank datafields, and only load the record when it is entered into the 'customer_membership_number'.
1. How do I clear the previous data from the form when It is loaded?
2. How do I relate the Customer_membership_Number entry text box(42) to the find button so it runs the database querry?
Many thanks
Sean
I am currently trying to program a video hire form for HNC Project. The form loads from two querries: the main form from 'Customers' table; the subform from 'Rental records 'table. The form loads fine with the main menu scroll bars running through the records.....but I need the form to load with blank datafields, and only load the record when it is entered into the 'customer_membership_number'.
1. How do I clear the previous data from the form when It is loaded?
2. How do I relate the Customer_membership_Number entry text box(42) to the find button so it runs the database querry?
Many thanks
Sean
