Input into a drop box

D

DaveB

I figured out how to do a combo box. Now I need to know
how to input information into the same field on my form,
and tell the field to let me do this; so that I can store
data in my table, info that isn't in my drop box already,
so that next time I need it, it will be in my drop box.
Please tell me how to do this.
 
J

Jeff Boyce

Dave

Check Access HELP on the LimitToList property, and the NotInList event. The
basic concept is that you'll type something new in, Access will notice that
the item isn't already in the source your combo box uses, and you can use
this to add the new item and requery the combo box.

Good luck

Jeff Boyce
<Access MVP>
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top