My first form (frmEnquiry) is a cus

[pleg12345]

My first form (frmEnquiry) is a customer details form which contains a unique customer number called enqID. The text box which contains this number is called EnquiryID.

My second form (tblCallB) is a separate independant customer check form which is related to the same table as the first form.

After completing the first form i want to click a button which takes you to the next form, so that i can fill in the check details, then save these details to the current record.

Unfortunately at the moment the customer check form does not relate to the same record as my customer details.

Can anybody help?

 

[nberryman]

Not sure I fully understand but try:

1. Use the form Wizard to create a Main Form / Sub form and see if that is suitable.

2. Use the Command button wizard on your form and select Form operations, Open Form and select the find specific record option and that should do what you want



Neil Berryman
IT Trainer
neil_berryman@btopenworld.com