Subform Focus - holding up the project

[Mich2too]

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!!

Know that I have posted this before but got no response.

 

[FoxProProgrammer]

Mich2too,

I can't figure out what is wrong with your form without seeing it. Since nobody replied to this question last time, I guess others are having the same problem. If you want to zip it up and email it to me, I'll look at it and see if I can figure out what is wrong.

Best, dz
dzaccess@yahoo.com