Referencing a toolbar combo box in MS Access

[Lauren Quantrell]

Is there a way to determine the value of a combobox that resides in a
toolbar other than using CommandBars.ActionControl? I want a user to
be able to change the combobox and be able to refer to the selected
value later, not immediately, and without having to set a public
variable.
This refers to the toolbar when adding a combobox to the toolbar:
CommandBars("myToolbarName").Controls.Add(Type:=ms oControlComboBox)
But what referes to the combobox once it's created?
Any help is appreciated.
LQ

[Lauren Quantrell]

I found a way to do this for anyone who had the same question:

'***START CODE***
Dim objBar As CommandBar, objCbo As CommandBarComboBox, myIndex As Integer
Set objBar = Application.CommandBars("myToolbarName")
Set objCbo = objBar.Controls("myComboName")
myIndex = objCbo.ListIndex
Set objCbo = Nothing
Set objBar = Nothing
'***END CODE***

la*************@hotmail.com (Lauren Quantrell) wrote in message news:<47**************************@posting.google. com>...

Is there a way to determine the value of a combobox that resides in a
toolbar other than using CommandBars.ActionControl? I want a user to
be able to change the combobox and be able to refer to the selected
value later, not immediately, and without having to set a public
variable.
This refers to the toolbar when adding a combobox to the toolbar:
CommandBars("myToolbarName").Controls.Add(Type:=ms oControlComboBox)
But what referes to the combobox once it's created?
Any help is appreciated.
LQ