Tab Control Question

[Friday]

Two tables, tblFacilities and tblFacAudits. Linked by fldFacID. Designed a form based on tblFacilities, and need to put a subform on there to store the audits. The tblFacAudits has about thirty fields (thirty different audit items). That's too many to display at once, so I built a tab control with 4 tabs on it and split the audits into 4 different subforms, one for each tab control. Problem is, if I create a new record, I enter the data on the first tab (Checkpoint Audit data) and go to the next tab (Physical Security) and I am no longer on the same record. How do you link the 4 subforms together? They are each linked to the main form (fldFacID) but not to each other (?). Does this make sense to anyone? I've never used the tab control before.

 

[dcx693]

I haven't had this particular situation, but why not create a subform where you have a tab control on it? Then just place your controls onto the desired tabs? They would all be on the same single subform, thus there would be no question of which would be the current record.

 

[Friday]

Pat's suggestion seemed the cleanest, but it wouldn't work for me. I suspect I have some design flaws with the db. DCX693's suggestion worked, so I am going with that. Thanks both of you.