Open Report From a ComboBox

[tcheck]

I created a simple form that has a dropdown of all the reports that a user can select. I am using the following command;

DoCmd.OpenReport "rpt_Roadshow2", acPreview, , "RoadShow.RSID = SelectSymbol.Column(0)"

Where SelectSymbol is the name of the ComboBox and Column(0) is the first column of that data field. When I run it I get



Run Time Error 3085
Undefined Function 'SelectSymbol.Column" in expression.

[ssanfu]

The combo box "SelectSymbol" selects the NAME of the report?
Then the command line should be

DoCmd.OpenReport Me.SelectSymbol, acPreview

Are you also trying to set a WHERE condition?

[ssanfu]

Oops... Hit the wrong button

You get the error because you have to concatenate the value of the combo box to create the where condition. Access is trying to evaluate the where clause; Access tries to execute what it thinks is a function: SelectSymbol.Column(0).

IF the bound column of the combo box was a number (not the report name) and you wanted to limit (filter) the records, the wherecondition you would use would look like:

DoCmd.OpenReport "rpt_Roadshow2", acPreview, , "RoadShow.RSID = " & Me.SelectSymbol

[tcheck]

That worked, thanks. I do not need the were at this iime.

[ssanfu]

Great. Ready to mark this solved??

[tcheck]

Yes. Thanks again.