Adding New Items in Combo Boxes

  • Thread starter Thread starter Carole
  • Start date Start date
C

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?
 
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
 
Thanks for the kind words ... but I'm not sure how to take the "long answer"
comment <g>!

Regards

Jeff Boyce

tkelley via AccessMonster.com said:
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.

Jeff said:
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
Click to expand...
[quoted text clipped - 4 lines]
allow
for new information to be entered as well. How do I correct this
problem?
Click to expand...
Click to expand...
Click to expand...
 
Back
Top