Tab Controls

Question

I have my main database page with tab controls. Is there any way I can have those tab controls reflect information from other forms that’s related to the master form? For example if my master form is just like an overview form and in the tab controls I have a tab information about a vehicle buyer. The vehicle buyers information is managed by another form.

Answer 1

So, I would create a main form bound to PendingCaseTbl. Place controls on the mainform that will display data from that table. Then add a Tab control. On each Tab place a subform bound to the related table(s) and linked on the key fields.

There is a bit of a trick to placing the subform on the Tab page. When you select the page then select the subform control from the tool box, when the cursor is within the tab page a shaded box will appear, draw the subform within that box.

Answer 2

Apologies for the late reply. I've been sick. Please see below. In the initial example I gave, it was based on vehicle sales which was a fake database but my actual database is based on court cases. As you can see below, I'm going to use my PendingCaseTbl as my overview form, which will allow my users to see an overview of their cases. Then I would like for the tab control to reflect the information of the case based from the other tables. I would like for the tabs just reflect the information on the forms where they input the information but if you can show me how I can add subforms within the tabs, that would be great. If you look a the second picture, you can see the layout of the overview form my users will be seeing.

Answer 3

Yeah I tried that but I keep getting the following error:

“cannot add record(s); join key of table...not in recordset"

That indicates a problem with your table structure. Can you show us your Relationships window

Answer 4

Yeah I tried that but I keep getting the following error:

“cannot add record(s); join key of table...not in recordset"

Answer 5

This is where subforms come into play. You can place a subform on a tab page. You can actually use the other form you have.