How to pass field name to query thru a form

[Prashant B]

I have a combo box on a form where i am having the list of fields from a table.
Now I want to pass the selected field name to a query.
Is it possible to do this?

[beacon]

Hi Prashant,

In your query, in the Criteria section, type the following (where FieldName is the name of the combo box field on your form...you'll need to change this to the actual name you're using):

=[Forms]![frmYourFormName]![FieldName]
 

Then, on your form, you'll need some way to launch the query. I would create a command button and add the following VBA in the OnClick event:

DoCmd.OpenQuery "YourQueryName"
 

This will run the query and filter out all results that don't match up with the field name you're passing to the query through your form.