Full Version: Updating Table from a Combo box entry
UtterAccess Forums > Microsoft® Access > Access Forms
I have a form with a combo box. The combo box selections are from a separate table. If the required entry is not in the drop down menu selections from the table, the user needs to type in the proper selection. If this happens I want the table driving the combo box to be automatically updated with the new entry so that the data will be in the drop down menu selections the next time. How is the best way of accomplishing this. Thanks.
Use the not in list event of the combobox. YOu first have to set the limit to list property of the combobox to Yes in the property sheet. Look at the Access help files for more details on how to code up the not in list event.
This is a "lo-fi" version of UA. To view the full version with more information, formatting and images, please click here.