Filtering by dropdown combo listbox

T

Tony Turner

I have a form based on a table.

I would like to set the filter by the selection of a user
in a combo box dropdown list. Anyone know how do to this?

Thanks,

Tony
 
J

John Vinson

I have a form based on a table.

I would like to set the filter by the selection of a user
in a combo box dropdown list. Anyone know how do to this?
Click to expand...

It's pretty straightforward. Create an unbound (no Control source)
combo box cboCrit on it. In your Filter use

=[Forms]!frmCrit!cboCrit

as a criterion.
 
Top