open an Access report for a specific record using a form button

[Guest]

I have two tables with separate information on customers, linked by a
Customer ID number.

I have a button on the Order Form that opens a report showing a summary of
the details from the other table. This report is based on a Query that asks
for the Customer ID to get the correct customer details.

I would like the button VBA Code to automatically insert the Customer ID so
the report opens with the correct customer's details.

 

[Rick B]

Asked and answered al the time.

Do a search and read the hundreds of previous posts on the topic.

 

[Rick B]

If you use the button wizard to build your button, it will even offer this
as one of the options!

 

[Guest]

I've just tried this, and there is no option to fin a specific report based

 

[Rick B]

Sorry. you're right. The wizard will do this for another foprm, but not a
report.

For a report, you have to specify the common fields using a where clause in
your vba code.

 

[Guest]

Thanks for coming back so quick.
I'm very new to VBA, and although I think I understand what you means, the
VBA language/Code is what I really need.

Having said that I will experiment.

Thanks again for taking the time to help.

Cheers