Pass listbox multi select to query

captnk

Registered User.
Local time
Today, 17:02
Joined
Dec 12, 2001
Messages
148
I have a listbox,multi, (list63),based which at its final point gives me a concatenated stringvalue.
eg :strvalue = "4/06/2003melb"

This is an identifying code used in another table/field.
I then run a query based on this code.
In a single select list box this works fine,however I need to automate the processa biy so multiple queries can be run.
How do I pass the listbox strvalue to the query pls.
The query is is simply a selection of fields from the underlying table and in the code field I have tried using
forms!tauto!list63!strvalue,as a parameter
but it doesnt find the strvalue????
 
In your list box, how many columns do you have?

You don't need to qualify your list box so much.

Forms!Tauto!list63 should be enough as a parameter.
 
Tks the replies.
I seems to have solved my problem by placing the strvalue in a textbox on the form with: me.textxx =strvalue
and then using a query to append to a temp table and looping it all as suggested by Pat.
May not be the most elegant way of programming,but it works,until I find a better way.
Thanks.
 

Users who are viewing this thread

Back
Top Bottom