Update Combo Box

[iamnu]

I have seen a commercial application where clicking on a Combo Box
displays a list of current values.
At the bottom of this list, there is a dotted line, and below this is
displayed "Edit List".
The doted line and "Edit List" text are both bold. And of course,
clicking on "Edit List" takes me to a place where I can edit the list.

I can handle the underlying code, I think, but how is the Combo Box
formatted this way (values above, and "Edit List" below), and can
someone show me how to do the same thing? It is just perfect for my
application.

Thanks for the suggestions...

 

[Arvin Meyer [MVP]]

You cannot do this with the native Access combo box.

 

[iamnu]

You cannot do this with the native Access combo box.

Alright then. Thanks for responding...

 

[DrGUI]

You can use a UNION query, for example:

select state fromtbl_States
UNION
select "--------" from tbl_States
UNION
select "Edit List" from tbl_States

 

[Balbina]

DrGUI, is there any way to get "Edit List" to show up italicized?

 

[DrGUI]

Unfortunately, No. You cannot format the items in a combobox.

 

[Arvin Meyer [MVP]]

You can use a UNION query, for example:

select state fromtbl_States
UNION
select "--------" from tbl_States

Clever!