Removing/Ignoring Query Criteria

[Montez659]

I have a query that will pull a report based on a repID that is chosen from a combobox. I added an option to show the report for all reps, but I am having trouble with the query because right now in the query I have criteria in the primaryRep column of

[Forms]![frm_ChooseRep]![txtRep]

The reason it is txtRep is because I tried putting the value of the combobox into txtRep, and when the checkbox for all reps was selected, it would change txtRep to something else (not sure, this is where I am stuck). I tried changing txtRep to be '>0' but that didn't work.

Any suggestions on how to do this? If I could default the combobox to "All Reps" instead of having to have a checkbox, that would be swell too. The combobox pulls from a query, and here is the string:

SELECT [Active Contacts Extended].ID, [Active Contacts Extended].[Contact Name] FROM [Active Contacts Extended] ORDER BY [Active Contacts Extended].[Contact Name];

Thanks in advance!

 

[alansidman]

Look at this video on search forms.

http://www.datapigtechnologies.com/flashfiles/searchform.html

You could make the search box a combo box also.

Alan

 

[Montez659]

Alan, thanks for the response. I will check into that video, but I realized that I could do what I wanted with the filtering via a simple DoCmd line in VBA as opposed to the Access Macro and query criteria that I had.

Thanks for the help!