linking forms on a tab control

  • Thread starter Thread starter Dick Minter
  • Start date Start date
D

Dick Minter

I want to use a tab control to separate linked forms
(master, sub1). I created the forms independently, then
placed each on a 2 page tab control, entering the linking
fields manually in the sub form's properties sheet. The
problem: Access seems to have accepted the link, and the
sub shows the correct data for the first master record,
but when another record in the master is selected (on page
1), none of the linked detail records records appear.
The syntax used was: child: fieldname. For the Master:
[formname].form![fieldname].

Any suggestions? Should [page1] have been in the master
link description? What is the proper syntax? Is there a
better way to do this?

DM
 
Tabbed forms act just like a single form. In the properties of the subform, you can set the Master/Child linked fields. Setting each of your two subforms this way allows Access to use the Primary/Foreign keys of your table relationships to link the forms.

Check the linked properties of each subform and make certain they are the same for each.
 
Doesn't work. I've tried this several ways: First using
the form wizard to create the form with linked subforms.
Then adding a tab control to a blank form and adding
linked forms and subsubforms to the tabs, but the link is
lost. The link wizard doesn't work to create the link.
When I manually add the link (copying from the wizard
created form, there is no error message, but the link only
works for the 1st master record.

I also tried adding the linked form (with imbedded
subforms) to the first tab, then coping the subforms to
another tab, but as above the link is lost.

DM
-----Original Message-----
Tabbed forms act just like a single form. In the
Click to expand...
properties of the subform, you can set the Master/Child
linked fields. Setting each of your two subforms this way
allows Access to use the Primary/Foreign keys of your
table relationships to link the forms.
Check the linked properties of each subform and make
Click to expand...
certain they are the same for each.
 
Back
Top