Query from a field list combo box

[M8KWR]

I have a form which has a combo box listing the fields from a table.

What i would like is to use the value with this combo box in a query in order to filter.

I.e. the user selects a value from the combo box on the form, the query will always state the the field "Is Not Null". So then once then update the combo box the fomr has other things on it will be updated according to the value that is selected.

I hope this is clear what i require, if not then please let me know.

Many thanks for any help in advance...

 

[PHV]

Have you tried the 3rd option of the combo wizard ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[M8KWR]

i do not think this will help as it assigns the field name to the row source of the combo-box, where as i need this to be changeable, but the "Is Not Null" but in the query to be static.

The form is like a dashboard view of a database. The user is able to change the database they want to query etc.

I have 1 main query, and other queries of this one in order to get the results for the user.

What i need is the main query to have this field from the combo-box that the user select and then query only on the data where this field have data within it.

I hope that makes sense... Or am i going about it all wrong, any guidance would be grateful.