Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Question on combo boxes...

Status
Not open for further replies.

Preka

Programmer
May 11, 2004
55
0
0
I was wondering if there was a way to do the following...

I have a combo box using tblorders.description as the control source. The row source is a seperate table. Typically speaking, there are only a few standard things going into the field this combo box is used for. Every now and then, however, there is an oddball entry that needs to be made, which the person placing the order can type in. Is it possible to make it so that, after they type that in, the new entry will be added to the source for the combo box options?
 
Take in the FAQ area of this forum: a whole section is devoted to combo.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244
 
Use the comboboxes _NotInList event to capture the new entry, add a new record in the source, and finally cancel the reponse to the user that the item is not in the comboboxes list (because it now should be!).
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top