Open an object listed in a Combo Box

  • Thread starter Thread starter Terry
  • Start date Start date
T

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
 
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
Click to expand...

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

Code the AfterUpdate event of the combo box:

DoCmd.OpenQuery Me!ComboName
 
fredg said:
The query name is the bound column of the combo box?

Code the AfterUpdate event of the combo box:

DoCmd.OpenQuery Me!ComboName
Click to expand...

Hi Fred,

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

SELECT QyeryList.Name FROM QueryList;

Works fine!

Thanks Fred
 
Back
Top