Open an object listed in a Combo Box

[Terry]

Is it possible to open an object from a Combo Box, (using the OnClick
event), by clicking on an item in the dropdown list?

I have a Combo Box which lists all queries in my database. I know it
can be done by adding a Command Button but I just wondered if this was
possible as I am short of space on my form.

Terry

 

[fredg]

Is it possible to open an object from a Combo Box, (using the OnClick
event), by clicking on an item in the dropdown list?

I have a Combo Box which lists all queries in my database. I know it
can be done by adding a Command Button but I just wondered if this was
possible as I am short of space on my form.

Terry

The query name is the bound column of the combo box?

Code the AfterUpdate event of the combo box:

DoCmd.OpenQuery Me!ComboName

 

[Terry]

The query name is the bound column of the combo box?

Code the AfterUpdate event of the combo box:

DoCmd.OpenQuery Me!ComboName

Hi Fred,

Actually it's an unbound ComboBox but the Row Source is set to:-

SELECT QyeryList.Name FROM QueryList;

Works fine!

Thanks Fred