D
David Nelson
Guest
I have two tables "Customer and Aftercare".
I have two forms "Customer and Aftercare".
Customer form is just data from the Customer
Table ie. CustID, LName, FName, City etc.
Aftercare form is CustID, Who, EnteredDate, Customer.LName, Customer.FName based on a query with Customer and Aftercare tables joined on CustID.
Problem:
When I do a filter-by-form on the Aftercare
form the Customer.Lname nor FName fields do not update when I select another record from the filtered Aftercare recordset. If I click on the Customer Button to select the customer form then select the Aftercare Button (on customer form) the name updates on the aftercare form but the filtering is gone and I have to run the filter-by-form again.
There is a string criteria set when switching
to and from forms set up by the wizard.
How do I get the names to update as I change records?
All help appreciated.
Dave.
I have two forms "Customer and Aftercare".
Customer form is just data from the Customer
Table ie. CustID, LName, FName, City etc.
Aftercare form is CustID, Who, EnteredDate, Customer.LName, Customer.FName based on a query with Customer and Aftercare tables joined on CustID.
Problem:
When I do a filter-by-form on the Aftercare
form the Customer.Lname nor FName fields do not update when I select another record from the filtered Aftercare recordset. If I click on the Customer Button to select the customer form then select the Aftercare Button (on customer form) the name updates on the aftercare form but the filtering is gone and I have to run the filter-by-form again.
There is a string criteria set when switching
to and from forms set up by the wizard.
How do I get the names to update as I change records?
All help appreciated.
Dave.