Multiple-Subform synchronization with single table

[Judyn2005]

I have a frm-Main that contains a two page tab control. Each tab contains a subform. Both subforms are from fields from a single table. This breakup was due to real estate constraints.

Each record in tbl-main has a unique index key (autonumbered).

It was assumed that data put in the first tab could be filtered on and then a user to go to the second tab and put in the rest of the required data. It appears however that when the record is recalled on the first tab it is not the corresponding record in the second tab.

How do in synchronize the two tabs so that when data is filtered on either tab it represents the exact same record.

Thanks,

 

[PHV]

Have a look here:
faq702-5860

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886