Using a form and a query to print particular records (how to)?

  • Thread starter Thread starter DavidMatyas
  • Start date Start date
D

DavidMatyas

Hi, I am trying to set up a form that will display the reults of a
query, then the user will be able to check of paticular records, and
click the print button and it will generate the report based on the
selection. ( i guess by automatically temporarily create a new query).

I am not sure how to go about this, so if someone can please tell me
clearly the best way of doing this.

Thank you
 
Dear David:

When the user clicks the print button, you should test in code whether all
the necessary selections have been made. If any are missing, inform the
user and do not invoke the report or form.

If you are creating an MDB, then the query can reference the controls on
your form directly. The syntax is:

[Forms]![FormName]![ControlName]

You can put that into the query just like you might enter a constant.

Tom Ellison
 
Back
Top