Pass multiple selected values from list box to table

[Jack]

How do I pass multiple selected values from a list box to a table?
I've found code to use the values as criteria in a query but would now
like to store the values in a table (at least temporarily)
thanks in advance.
jack

 

[ryguy7272]

Pass selected values from a list box to a table? I don't really think you
want to do this. Can you describe more about what you are trying to
accomplish?

You just store raw data in a table. You don't store manipulated data in a
table. Maybe you need a query to do what you want to do...

 

[Kleber]

Hi Ryan,

Well, I want to use form with 4 or potentially more multiple selection
listboxes to select values to be used as criteria for different
columns in a query.

I found the following example to use values from a listbox as criteria
which worked well with one listbox: http://www.databasedev.co.uk/query_using_listbox.html
But I couldn't find out how to apply the same for multiple listboxes
and came across the following: http://www.tek-tips.com/faqs.cfm?fid=1927.
It seemed an easier way but therefore I neeed to know how to populate
the mentioned temporary tables.

So maybe it's better to rephrase my question: How can I make the query
work for multiple listboxes?

The above probably shows that I'm completely new to this...
Thanks in advance

Regards,

jack

 

[ryguy7272]

Here ya go:
http://www.fontstuff.com/access/acctut18.htm
Download the file at the bottom of this page:

'AccessAndSQL5_2000.zip [122KB]'

Good luck with the project!! Sounds exciting!!

 

[Jack]

Here ya go:http://www.fontstuff.com/access/acctut18.htm
Download the file at the bottom of this page:

'AccessAndSQL5_2000.zip  [122KB]'

Good luck with the project!!  Sounds exciting!!

--
Ryan---
If this information was helpful, please indicate this by clicking ''Yes''..

Hi Ryan,

Well, I want to use form with 4 or potentially more multiple selection
listboxes to select values to be used as criteria for different
columns in a query.

I found the following example to use values from a listbox as criteria
which worked well with one listbox:http://www.databasedev.co.uk/query_using_listbox.html
But I couldn't find out how to apply the same for multiple listboxes
and came across the following:http://www.tek-tips.com/faqs.cfm?fid=1927.
It seemed an easier way but therefore I neeed to know how to populate
the mentioned temporary tables.

So maybe it's better to rephrase my question: How can I make the query
work for multiple listboxes?

The above probably shows that I'm completely new to this...
Thanks in advance

jack

Thanks a lot!

.

 

[ryguy7272]

Please give some feedback if I helped you.
Thanks!

--
Ryan---
If this information was helpful, please indicate this by clicking ''Yes''.

Here ya go:http://www.fontstuff.com/access/acctut18.htm
Download the file at the bottom of this page:

'AccessAndSQL5_2000.zip [122KB]'

Good luck with the project!! Sounds exciting!!

--
Ryan---
If this information was helpful, please indicate this by clicking ''Yes''..

Hi Ryan,

Well, I want to use form with 4 or potentially more multiple selection
listboxes to select values to be used as criteria for different
columns in a query.

I found the following example to use values from a listbox as criteria
which worked well with one listbox:http://www.databasedev.co.uk/query_using_listbox.html
But I couldn't find out how to apply the same for multiple listboxes
and came across the following:http://www.tek-tips.com/faqs.cfm?fid=1927.
It seemed an easier way but therefore I neeed to know how to populate
the mentioned temporary tables.

So maybe it's better to rephrase my question: How can I make the query
work for multiple listboxes?

The above probably shows that I'm completely new to this...
Thanks in advance

jack

Thanks a lot!

On 11 mei, 17:21, ryguy7272 <[email protected]>
wrote:
Pass selected values from a list box to a table? I don't really think you
want to do this. Can you describe more about what you are trying to
accomplish?

You just store raw data in a table. You don't store manipulated data in a
table. Maybe you need a query to do what you want to do...

.

.