Combo Box .Value used in Reports![???????].Filter = strSQL

C

Corn Dog

Ok this is SOME of the code I have in a form that opens a
report based on the value chosen from a combo box Combo0.

Private Sub Combo0_Click()
DoCmd.OpenReport Me!Combo0.Value, A_PREVIEW 'Open
Customers report.
DoCmd.Maximize 'Maximize the report window.
ChosenRpt = Me!Combo0.Value
End Sub

..
..
..

Reports![rptCustomers].Filter = strSQL
Reports![rptCustomers].FilterOn = True

Problem is the [rptCustomers] is static, I cant figure out
how to get the Me!Comb0.Value to work with the
Reports!........Filter = strSQL

Anyone know what I need to put?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Filter report from pop up form 0
Using a filter to show results on a report 6
How to modify: Filter from a pop-up form 1
Dynamic Filter of a Subreport Problem 0
Hide combo box with check box on another form 3
Filter a form using a popup form 0
two questions on exporting from a form 3
Type Mismatch 1

Top