View Full Version : Filter Query using List Box


tarcona
06-16-2008, 06:45 AM
Hi, I searched the forms and I didn't find an answer.
Anyways, I have a form called 'Report Generator' in which I have a combo box called 'cmbLeadSource' in which the selections are 'Web, Phone, and Email'. I want the user to select one of the sources from the combo box and then click on a button to bring up a filtered query or report showing records that were sourced by the web (for instance) if the user selected 'Web' from cmbLeadSource.

Any help would be awesome. Thanks.

pbaldy
06-16-2008, 08:04 AM
The title says listbox but you describe a combo. I mention it since it could change the answer. If it's a combo (or single select listbox), you can refer to it in the criteria of the query:

Forms!FormName.ComboName