Select Report Based on Field

  • Thread starter Thread starter David Habercom
  • Start date Start date
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.
 
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), . . .
 
Back
Top