Linking subform to mainform

[Slez via AccessMonster.com]

I am having trouble linking the fields properly so that the subform records
match the mainform record.

The mainform is an unbound combo box, Combo4, whose Row Source is:
SELECT qryCurrentProjects.JobNumber, qryCurrentProjects.ProjectName FROM
qryCurrentProjects;

The subform's Source Object is: qryActiveHoldItems, which is a query that I
created to gather records in which the field ItemStatus is either "Hold" or
"Active".

With nothing defined in the Link Child Fields and Link Master Fields
properties, it as you would expect, shows all records from the query. If I
enter JobNumber as the field in both properties, it prompts me for JobNumber
when I switch to form view. I've tried a number of different query and form
references by trial and error without it relating the proper data. I have a
similar form/subform combination that gets its data directly from the tables
that works fine, so my feeling is that I need to define the Master/Child
relationship differently because I'm pulling from 2 different queries.

Help is appreciated!

 

[Allen Browne]

Try setting the Link Master Fields property to: Combo4

The Link Child Fields should contain the name of the matching control in the
subform.

 

[Slez via AccessMonster.com]

I almost hate it when it comes down to such a simple solution! It works
properly now!
Thank you so much for the help!
Slez

Try setting the Link Master Fields property to: Combo4

The Link Child Fields should contain the name of the matching control in the
subform.

I am having trouble linking the fields properly so that the subform records
match the mainform record.

[quoted text clipped - 23 lines]

Help is appreciated!