Record Source issues?

[rebecky via AccessMonster.com]

I am searching a form with a subform (search field is in subform) for a
particular job type using a query as the record source.
Consequently, when the user scrolls through the employers(main form), they
have to see the employer 18 times on the main form if there are 18 entries in
the subform for that employer. And that would be ok if the subform showed a
different entry 18 times, but it shows the top job order over and over.
How can I fix this?

I want the Employer to show once as it does when the record source is the
table itself and not a query, and then the user scrolls through the subform
entries.

Any ideas?

 

[Golfinray]

Use a search combo box. On the mainform, put in a combo box and use the
wizard to look up employer. Right click on the combo box to get properties.
On the Afterupdate property, click on the little button to the right and
start the code builder. Type:
Me.filter = "[employer] = """ & Me.combo# & """"
Me.filteron=true
The combo box number will be listed and will be something like combo8 or
combo22.