Big form with 5 tabbed control 1 tab via 1 table and the other tabs via another table

[joe789]

Hi Folks,

I have a form with a 5 tabs in it via tab control, 4 of the tabs are based on one table and one of the tabs is based on another table. The two tables share a unique key, both named 'ID' that allow me to join the data from both tables successfully. I have been trying everything to attempt to synch the 'ID' on the first table (the 4 tabs of data) with the 'ID' on the second table (the 1 tab of data) together so that the one tab will always and only show data that goes with the primary table (the 4 tabs). I have tried to use filter on the form and it doesn't work or render an error. There will always be exactly a 1-to-1 relationship between the two tables. Any ideas?

Thanks for any help you can provide.

 

[joe789]

Figured it out ...

I just used filter on load and [Subform]![IDField] = [Forms]![FormName]

 

[rodmc]

why would you need to sync the ID's? the data can be related without syncing the ID's from the 2 tables, you do realise that? unless im picking you up entirely wrong

 

[vbaInet]

Lovely job!

But, when you move between records it will no longer be in synch.

We've answered this question many times. Perform a search on the forum under the Forms and Modules section for the solution. If you're not having any luck let us know.