Tab page problems

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

(Sorry if this is a duplicate. Not sure if my first message posted...)

I am trying to design a multi-tabbed form that uses one selected field to
pull information into the various tab pages. I read that the field should be
cut (Cntl X) from the sub-form of the first tab page and pasted (Cntl V) on
the first tab page. I've tried this, but it's not working properly.

Here's a simplistic example of what I'd like to accomplish:
1. Tab 1 - select vendor name from Combo Box (pull-down list), which
populates vendor address in form
2. Select 2nd tab and form shows vendor contact info
3. Select 3rd tab and form shows vendor notes

I've set the Master & Child Link as the vendor name. The sub-forms do not
contain this field.

Your comments or reference to a specific tutorial are appreciated. If
needed, I can send a screenshot by email.

Thank you,
Janice
 
It isn't real clear what the "Value" of your combo box is. Your combo box
should have a bound column that returns the primary key value of your vendor
table. Each subform must have this same value in a column in its record
source. You can then set the Link Master/Child properties to the combo box
name and the field name from the subform.
 
The value of the combo box is the Vendor Name, which is what I'm using as to
link Master & Child. All sub-forms on additional tab pages contain the Vendor
Name. I've linked form/sub-forms previously, just never within tab pages. Do
you know of a tutorial that specifically shows multiple tab pages and how to
set them up using one common field (eg. Vendor Name)? I'm probably just
missing a small detail or step.
Thanks,
Janice
 
Do you have subforms on your tab pages? If so, then you use link
master/child. There is no difference when the subforms are on a tab or not.

I would avoid using a name to perform the linking but if your names are
always unique, I expect it should work.
 
Back
Top