Update Combo Box

  • Thread starter Thread starter iamnu
  • Start date Start date
I

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...
 
You can use a UNION query, for example:

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