COMBO BOX

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

skk - 08 Jan 2008 17:54 GMT

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

Reply to this Message

KARL DEWEY - 08 Jan 2008 18:04 GMT

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.

Signature

KARL DEWEY
Build a little - Test a little

> 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

Reply to this Message

Dale Fye - 08 Jan 2008 18:27 GMT

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

Signature

Don''t forget to rate the post if it was helpful!

email address is invalid
Please reply to newsgroup only.

Reply to this Message