Combo Boxes

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a combo box with values from a table. I want to have a command button next to the combo box to open a report based on the result of the combo box. For example if value in combo box is accounting then oopen the report named accounting. How can I do this in vb.
 
George said:
I have a combo box with values from a table. I want
to have a command button next to the combo box to
open a report based on the result of the combo box.
For example if value in combo box is accounting then
open the report named accounting.
How can I do this in vb.
Click to expand...

The VBA code in the button's Click event procedure would
look something like:

DoCmd.OpenReport Me.thecombobox, acViewPreview

as long as the combo box's bound colunm is the column that
contains the exact name of the report to be opened.
 
Back
Top