Am working with a tabbed form showing 4 subforms on it (all subforms are on one page of the tabbed form). The main subform (Active Orders Subform) lists all of our current orders being worked on. The other subforms show the customer, pick up location, and destination respectively. The customer subform Link Child field is set to ID and Link Master field is set to [ACTIVE ORDERS subform].Form![CustomerID].
The problems:
1) when a different record is selected on the Active Orders Subform, the customer subform does not change to represent the new information.
2) all 3 subforms (customer, pick up location and destination) pull information from the same table. Which means that if one subform pulls information from the table, the others should too. However, neither of the later subforms will pull the information and gives an error when the form is opened looking for the ID field.
Thanks in advance!!
The problems:
1) when a different record is selected on the Active Orders Subform, the customer subform does not change to represent the new information.
2) all 3 subforms (customer, pick up location and destination) pull information from the same table. Which means that if one subform pulls information from the table, the others should too. However, neither of the later subforms will pull the information and gives an error when the form is opened looking for the ID field.
Thanks in advance!!
