Select criteria based on the field name the user selects

[Raj]

Hi all,

I am facing with aproblem where in i have a small access db
with forms and reports now i want to change or set the where condition
of a query based on the value the user selects from the form through a
combo box. For ex:- if user is selecting Invoice_date then the where
condition should search based on invoice date if the user selects any
other field the querys where condition should search based on that
particular field.Can any one help me in getting a solution for this.

 

[Ken Snell \(MVP\)]

I have a sample database that shows how you can use various controls to set
the filter of a query that is then used for report, etc.
http://www.accessmvp.com/KDSnell/SampleDBs.htm#FilterForm