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

  • Thread starter Thread starter mruss007
  • Start date Start date
M

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.
 
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.
 
Back
Top