UPDATING CUSTOMER NAME AFTER FILTERING (1 Viewer)

[David Nelson]

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.

 

[Pat Hartman]

The normal process is to have the main form control what is displayed on the subform not vice versa. If you want Aftercare to control what Customer is displayed, change the process to use Aftercare for the main form and Customer for the subform.