Passing values into a report

[Nancy]

Hello -

My user wants to pass a customer number into a report and to only have the
report retrieve data for the customer. Is there a fairly simple way to do
this?

 

[Rick B]

Sure, you base your report on a query then put that criteria in your query.
Under the customer number, put something like...


=[Enter Customer to Print]

 

[Ofer Cohen]

Try this link on "Printing the Record on the Microsoft Access Form to a Report"

http://www.databasedev.co.uk/report_from_form_record.html

that way the user can select a customer from a list, and then click a button
to open a report giving details for that customer

 

[Damian S]

Hey, you just changed to a gold icon... congrats!!

D.

 

[Ofer Cohen]

Thanks, but not yet.
In this discussion group it still bronze, but I admit it's looks like gold