Query with drop menu

[kepezzo]

Hello !

I am trying to build a query where you would select condition from drop menu. Is it possible at all ? Maybe in SQL ?
So far I have used this form [Choose proejct:] in condition. Can be this changed with above mentioned WISH !

THNX !

Klopo

 

[freakazeud]

re:

Hi,
sure...create a new custom form...add a combobox to the form which holds all possible values...now reference this form control in the criteria section of your query field e.g.:

[Forms]![YourForm]![YourComboControl]

Put a button on the form which runs the query or opens a form/report based on the query. The form has to be open at query run and the value you are trying to reference has to be in the bound column of the combobox.
HTH
Good luck