Combo Box - Adding an item to the existing List

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a combo that lists all items from a table.
That's fine, but I want to add an item to that list, preferrably at the top.
Is there a way to do this in code without having to add the item to the
source table?

Regards
Richard
 
Why would you do that? That would get pretty darn confusing down the road.
Why can't you add the item to the source table?
 
On occasion, I use filtered lists in combo boxes, for instance to have
options available here that I do not want the user to edit or remove when
editing the table that is the RowSource of this combo box.

To do this, add your entry to the table manually. Add another Yes/No field
to your table; let's call it System. Set it to False for all entries except
the one you want to add; set that one to True.

Then, in the combo box RowSource, filter to System = False.
 
OK - My combo is unbound, and used to set filter criteria. The additional
value I want to add to the table is "All". i.e. make the user explicitly
aware that selecting "All" will result in searching for all values in the
combo (same as leaving it blank). I cannot easilly add this to the table as
it is completely over-written every night by another application! Sorry,
maybe this is too complex for this place.
 
Probably easier to just tell the user to clear the box when he wants to see
all the records.
 
Back
Top