Create ComboBox Filter

[rlsublime]

I have a form with a combo box that I am trying to add a filter to. i would like to filter the data by type and date (To and From) and then export those results to excel. i know there is a way to do it with combo box filters and requery methods but am not sure of how exactly.

The first is a combo list box called request type which contains let's say A,B,C,all. I also have a (date from) and (date to) input box which I am also trying to use as the second filter to filter the dates entered by the user and the request type. I have created a macro button to export the report query to excel but I am trying to add the appropriate filters to the query before exporting to excel.

Also, when (all) is selected, I do not want the filter to apply to (request type).

Thanks

[June7]

Review the links referenced in this thread https://www.accessforums.net/showthr...erate-a-Report!!

[rlsublime]

Thanks. If I have a combo box called Request_type in a form, would I got to data and edit the row source field? What would I need to enter there for me to filter the Request_type field in Query1? I created the "Requery" After Update event but I am having problems with the "row source field" in the properties data tab.

Thanks

[June7]

Don't understand the question: "would I got to data and edit the row source field?"

Re-check you effort against the tutorials.