How to pass query result to a from that contains subforms?

[mruss007]

I am a new user of Access 2003 and need some help. I would like to pass data,
such as an account number, to a form that contains subforms so I can display
the records for that account.

If I use a parameter query it is tied to only one table and not to all of
the several tables used for the form containing subforms. This probably has a
simple answer if I was able to state my question correctly.

 

[Duane Hookom]

IMHO, parameter queries are never appropriate user interface. You should use
controls on forms for all user interaction. You can then reference the
controls in the Record Sources of your subreports.