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????
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????