COMBO BOX

  • Thread starter Thread starter skk
  • Start date Start date
S

skk

I have a combo box that list 3 names (Sean, Scott, Shelley) to choose from in
my form. Can I enter a new name and have that name recalled in the list of
names to choose from without going into the design view each time?

Thanks for all help,
Sean
 
If you go into the design and change source to a table/query you can. Use a
table and query combination so if one is old/obsolete it can be marked
(Yes/No field named Old) and query criteria not pull the record.
 
Sean,

Usually, values for a combo box will come from a query or a table, rather
than just a list of values. The advantage of using a table/query for these
values is that it is easy to change the values or filter them for a
particular purpose.

Combo boxes have a LimitToList property, set this to Yes. They also have a
NotInList event. Look this up in help to find a code example for how to add
a value to a table that is used by a combo box as its RowSource.

HTH
Dale
 
Back
Top