Get List Box Items with VBA

94Sport5sp

Registered User.
Local time
Today, 11:03
Joined
May 23, 2012
Messages
115
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
 
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 :confused:
 
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 :confused:

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
 

Users who are viewing this thread

Back
Top Bottom