Form/Subform question

  • Thread starter Thread starter marf
  • Start date Start date
M

marf

I have a main form that contains several tabs. The main tab contains all the
primary information about a project, the 2nd tab contains the latest update,
the 3d tab contains issues with each project, the 4th a list of approvers for
that project, etc.

Here is my issue,

I want to select a record in the 1st tab and when I click on any of the
other tabs, I want the other tabs to show ONLY the records associated with
the record selected in the 1st tab. Right now, each subtab shows every record
everytime...
 
Is the data on tabs 2-4 in subforms?
If so, is the data on tab 1 the main form?
If both of the above are true, is there a field or fields that relates the
record source of the main form data and the subforms data?
If all the above is true, you can use the Link Master and Link Child
properties of the subforms to filter their record sources to show only the
records related to the record on the main form. You put the name of the
field(s) from the main form's recordset in the Link Master Field(s) property
of the subforms, and the name of related the field(s) in each subforms
recordset in the Link Child Field(s) property.
 
Klatuu:

The answer is yes to all your questions. However, when I try to set the
Master and Child property, it tells me it cannot link unbound forms...
 
The message in effect is saying that the wizard cannot work not that
the parent child relationship will not work.

Type the field name(s) into the two fields manually and it will work.

Ron
 
Okay (funny)
Lets be sure. One the first tab where the project info is... is it a
subform also, or are the controls for the data on the main form?
Are the controls bound to fields in a record source for the form, or do you
load the data in the controls programmatically?
 
Back
Top