Hi there,
I have a form that contains customer details. A search can also be performed - and if the customer exists the details show up in a subform (based on a query).
I then have buttons to either select the customer from the query, or create a new customer.
Is it possible, that when the button to select the customer is clicked, the details from the subform are used to populate the text boxes on the mainform?
The form is 'frmEnquiry', subform 'subfrmCus' and example field is 'Customer_No' with textbox 'txtCusNo' on mainform. I am using Access 2003.
Cheers
Rob
I have a form that contains customer details. A search can also be performed - and if the customer exists the details show up in a subform (based on a query).
I then have buttons to either select the customer from the query, or create a new customer.
Is it possible, that when the button to select the customer is clicked, the details from the subform are used to populate the text boxes on the mainform?
The form is 'frmEnquiry', subform 'subfrmCus' and example field is 'Customer_No' with textbox 'txtCusNo' on mainform. I am using Access 2003.
Cheers
Rob
