Open report from form

[asu81]

Hi!
I'm new to Access and have a question..

I have a form with several combo-boxes in which to choose parameters. Next to each combo-box I have an "OK" button with VBA code which opens a specific query with previous chosen value in related combo box as filtering parameter.

Each button opens a separate query.
So far so good.


Now, I want to view a report of the chosen query when hitting OK, instead of the query itself.

I haven't worked with reports before, so I'm unsure about how to proceed.

Can I simply create a related report for each query and then exchange "DoCmd.OpenQuery XXX" with "DoCmd.OpenReport YYY" in the form button VBA?

Thanks!

 

[boblarson]

1. I would make a generic report if possible and then
2. Call it from the code and pass a Where Condition to it to filter instead of having multiple queries with different criteria.

See my generic report sample here for ideas:
http://downloads.btabdevelopment.com/Samples/reports/Sample-GenericReport.zip

 

[asu81]

1. I would make a generic report if possible and then
2. Call it from the code and pass a Where Condition to it to filter instead of having multiple queries with different criteria.

See my generic report sample here for ideas:
http://downloads.btabdevelopment.com/Samples/reports/Sample-GenericReport.zip

Thanks, I'll look into it!

In what ways is this method superior to my method?