Adding New Items in Combo Boxes

[Carole]

I have set up a new form that has multiple combo boxes. The form works great
as long as the information is already contained in the list. However, when I
am adding a new client, it will not populate the field because the
information entered is not on the list. I thought the combo box would allow
for new information to be entered as well. How do I correct this problem?

 

[tkelley via AccessMonster.com]

The short answer is to make sure your 'LimitToList' property on the combo box
says no.

 

[Jeff Boyce]

I disagree with the response that suggests allowing anything to be added to
the list (LimitToList = no).

I would suggest setting LimitToList to Yes, and using the NotInList event as
Access HELP describes, to help ensure that new values added to the
underlying source of data (a table, right?) are properly added before
returning to the combobox to find the new value added.

JOPO (just one person's opinion)

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[tkelley via AccessMonster.com]

Jeff is 100% right, as he usually is. His suggestion is the long answer. If
you're building an application to be used by other users, and you have coding
experience, his way is the only way to go to ensure data integrity.

Sometimes people are just looking for the short answer ... hence my most
simple suggestion.

If the Access HELP isn't clear to you, check this out:

http://www.everythingaccess.com/tutorials.asp?ID=NotInList:-Adding-values-to-lookup-tables


Or you can google "access vba not in list"

Good luck.

I disagree with the response that suggests allowing anything to be added to
the list (LimitToList = no).

I would suggest setting LimitToList to Yes, and using the NotInList event as
Access HELP describes, to help ensure that new values added to the
underlying source of data (a table, right?) are properly added before
returning to the combobox to find the new value added.

JOPO (just one person's opinion)

Regards

Jeff Boyce
Microsoft Office/Access MVP

I have set up a new form that has multiple combo boxes. The form works
great

[quoted text clipped - 4 lines]

allow
for new information to be entered as well. How do I correct this problem?

 

[Jeff Boyce]

Thanks for the kind words ... but I'm not sure how to take the "long answer"
comment <g>!

Regards

Jeff Boyce

Jeff is 100% right, as he usually is. His suggestion is the long answer.
If
you're building an application to be used by other users, and you have
coding
experience, his way is the only way to go to ensure data integrity.

Sometimes people are just looking for the short answer ... hence my most
simple suggestion.

If the Access HELP isn't clear to you, check this out:

http://www.everythingaccess.com/tutorials.asp?ID=NotInList:-Adding-values-to-lookup-tables


Or you can google "access vba not in list"

Good luck.

I disagree with the response that suggests allowing anything to be added
to
the list (LimitToList = no).

I would suggest setting LimitToList to Yes, and using the NotInList event
as
Access HELP describes, to help ensure that new values added to the
underlying source of data (a table, right?) are properly added before
returning to the combobox to find the new value added.

JOPO (just one person's opinion)

Regards

Jeff Boyce
Microsoft Office/Access MVP

I have set up a new form that has multiple combo boxes. The form works
great

[quoted text clipped - 4 lines]

allow
for new information to be entered as well. How do I correct this
problem?