Tabbed Records

[dynamictiger]

I am trying to make a super compressed form of information. I have a series of sub-forms on the master form to achieve the desired outcomes. For the main this is working well.

In one sub form I require a tabbed form. I am trying to force the recordset to be one recordset to facilitate linking to the main form. This is a nested subform.

However, I am trying to display all records pertaining to this client on my subform. Something like Husbands Car, Wifes Car, Sons Car etc. So I want to reset the recordource, I think, in the click event of the tab. However, this is not running????

Anyone done something similar before, got an idea?

 

[Dgavilanes]

did you check the relationship between the main and the nested subform Example Main ID is (primary key) and the nested form is
(sub Id= number) one to many .
So the main record is "Mikey Mouse" on the many side, cars boats etc.

Dennis