Use multi-Select list boxes as query parameters

[Autoeng]

I am trying to integrate this (

http://www.mvps.org/access/forms/frm0007.htm)

into my db but am not sure as to what event to assign the code to. I created my multiselect list box pulling values from my query. Created a hidden test box to store the WHERE clause. Created a command button to run the query. Does the code go in the Lost Focus event of the hidden text box? I tried it here but got a Syntax error on the last statement. I'm using A2K on WinNT4.0.

In addition, can anyone think of a way to;

Add a second set of multiselect list boxes containing a second set of default criteria (greater than, less than, ect.).

Add check boxes above each field on the form so as to display the field in the query results or not.

Autoeng

 

[Darrylles]

Hi,

An 'hidden' text box can not ever HAVE focus - how can it ever lose focus?

Why not put it in your button?

Regards,

Darrylles

"Never argue with an idiot, he'll bring you down to his level - then beat you with experience."

 

[jebry]

Hi!

It may be helpful to post the code you are using to transfer the information from the list box to the text box.

Jeff Bridgham
bridgham@purdue.edu