Linked Data in SubForms on TabCtl

  • Thread starter Thread starter Gary
  • Start date Start date
G

Gary

I have a main form with customer info.
It contains a TabCtl with several Tabs.
Each Tab has a Subform on it.
Some of the Subforms have List Boxes.

How do I make the data on the
Subforms, ListBoxes & all, be linked
with the Main form.

When I advance the records on the main form,
the subforms don't reflect the right data.

How do I do this?

Thanks for any help.
 
Gary said:
I have a main form with customer info.
It contains a TabCtl with several Tabs.
Each Tab has a Subform on it.
Some of the Subforms have List Boxes.

How do I make the data on the
Subforms, ListBoxes & all, be linked
with the Main form.

When I advance the records on the main form,
the subforms don't reflect the right data.

How do I do this?
Click to expand...

This is done by making the appropriate entries in the MasterLink and
ChildLink properties of the subform control. The fact that the subforms
happen to be on a TabControl is not relevant.
 
When I dragged the Subforms onto the
individual Tabs the ChildLink & MasterLink
fields were set automatically.
But when I move from record to record in the
main form my subforms aren't keeping up.
Do I have to set a requery or refresh somewhere?
 
When I dragged the Subforms onto the
individual Tabs the ChildLink & MasterLink
fields were set automatically.
But when I move from record to record in the
main form my subforms aren't keeping up.
Do I have to set a requery or refresh somewhere?
Click to expand...

First off make sure that the fields that Access automatically put in those
properties are the correct ones. Sometimes they're not. If they are you
"shouldn't" have to issue Requery commands, but I have seen cases where
you do. I would actually issue a Me.SubformControlName.Requery in the
Change event of your TabControl testing for the selected page. That way
you are only issuing the Requery to the subform that is going to be viewed.
 
Back
Top