Select Report Based on Field

D

David Habercom

I have a dropdown list based on a query. The list shows
only names, but the query includes a field which
determines which report to open. What is the most
straightforward method to have the field make that happen?

Thanks.
 
M

Marshall Barton

David said:
I have a dropdown list based on a query. The list shows
only names, but the query includes a field which
determines which report to open. What is the most
straightforward method to have the field make that happen?
Click to expand...


How does the field in the combo box's query relate to the
name of the report?

If it's the actual report name, then it's as simple as:

DoCmd.OpenReport Me.combo.Column(x), . . .
 
Top