report selection criteria

  • Thread starter Thread starter Jean
  • Start date Start date
J

Jean

Can anyone tell me the best way to put a selection criteria on a report?

I have a grouped report returning all records on the table with a page break
after each group to give me an Invoice per page.

I have a form that the user keys data into, I have added a button to preview
an invoice however I appreciate that I have to put on selection criteria to
preview only the invoice that relates to the current record on the form.

Any help would be appeciated.

Thanks

Jean
 
Jean,
Just use a criteria in the query behind your report that refers to the
value from the form record you're on. That record should have a unique
identifier (key) field such as InvoiceNo.
In the report query on the InvoiceNo field, use this criteria...
=Forms!frmYourForm!InvoiceNo
When previewing, only that Invoice will be reported.
hth
Al Camp
 
Thanks Al, this has worked a treat

Jean

Al Camp said:
Jean,
Just use a criteria in the query behind your report that refers to the
value from the form record you're on. That record should have a unique
identifier (key) field such as InvoiceNo.
In the report query on the InvoiceNo field, use this criteria...
=Forms!frmYourForm!InvoiceNo
When previewing, only that Invoice will be reported.
hth
Al Camp
Click to expand...
 
Back
Top