Applying Filter for Reports based on Queries 1

[Heraldo]

I have 7 queries with 7 reports and a user form, with combobox to select which report should be selected. I want to give the user a filtering option by way of another combo box / List box, on this form, which would select report results based on a field in the query.
I'm stumped as to what type of code I should write and where I should put the code.I have looked at many existing threads, and applied various examples of code behind the command button, but found nothing that applies that well
Any pointers in this direction would be appreciated.

 

[hneal98]

have the query reference the text property of the combobox.

Something like this:

 =Form!FormName!cboName.text

where the FormName is the name of your form and the cboName is the name of your combobox.

I think I have that correct, if not, you should be able to find it in help.

 

[Heraldo]

Cheers Hneal98, got that sorted and working!

 

[hneal98]

Great.