How can you add a drop down box to a query

[vince99]

Is there a way of adding a drop don box to a query in order to select criteria?


Thanks

 

[BlackKnight]

Hi,

No there isn't any way to put a listbox in a query. Normally, you would have a form that has a lsitbox with the cirteria in it so the user can select it and then run the query.

Another way is to insert into the query a reference to the listbox on a form whcih contains the criteria you wsh to use.

Another way is to build an SQL string from values selected in a various listboxes and then run the SQL statement.

Have a good one!
BK