COMBO BOX

[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

 

[KARL DEWEY]

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.

 

[Dale Fye]

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