MultiSelect listbox as a Parameter in a query (97)

Topic

New Reply

I have a MultiSelect listbox on my form that has 4 columns(ID, NAME, Version,Price) . If i select more than one row how can I pass the vaules to a query. Does this make sense?
Thanks
dgw

Reply | Quote

Replies

It makes alot of sense; unfortunately I don’t think it can be done. You can use it to create a WHERE clause for use in an OpenReport or OpenForm, but not a query.

Reply | Quote

What you could do is dynamically build the query and use a CreateQueryDef command to create the query.
Pat

Reply | Quote

How about having a temp table (ie. a table that normally has no records) then inserting the values selected from the listbox into the table, and using the values from the table as the parameters for the query?
e.g. where fieldname in (select * from tbltemp)
You would also need a delete query to clear the tmep table out again.

Reply | Quote

Check the link http://support.microsoft.com/default.aspx?…b;en-us;q135546%5B/url%5D out as well.

Reply | Quote