Get List Box Items with VBA

[94Sport5sp]

Hi:

On my form I have a List Box which has a query as a data source. I would like, within VBA, to get all the items in the list. Is there a way to do this or do I have to define a recordset to access the list. Note: I know how to get the item the user selected. Now I would like to see the items not selected by the user.

Thanks

 

[John Big Booty]

I'm not sure I follow what you are trying to do. But surely the query you are using as the Row Source for your List box already has all the items

 

[94Sport5sp]

Hi John:

I'm not sure I follow what you are trying to do. But surely the query you are using as the Row Source for your List box already has all the items

Yes the list box has all the items listed and when the user selects an item from the list I can retrieve the item selected. Now I would like to see the item NOT selected and then do some processing on the unselected items.

I know I can do this with a record set using the same query of the list box and restrict the list by what the user selected from the list box. Just, it that the best way?

Thanks

 

[jdraw]

There is an interesting video tutorial here that should help
http://www.datapigtechnologies.com/flashfiles/listboxtrick.html

 

[John Big Booty]

Another option would be a variation on the code here.

 

[94Sport5sp]

Hi jdraw

There is an interesting video tutorial here that should help
http://www.datapigtechnologies.com/flashfiles/listboxtrick.html

Thanks for the interesting link

Hi John

Another option would be a variation on the code here.

Yes ItemData may do what I want.

Thanks for the link