Insert a value into a combo box with one line of VBA code.
Have you ever wanted to add an item to a
combo box or list box while you're in the middle of entering new
records? It's annoying to have to stop and load up the other form, add
the value, close the form, and then find that the combo box hasn't
updated itself with the new value! Frustrating. In this Microsoft Access
video tutorial, you will learn how to add a record to a combo box
with a simple 2nd form and one line of VBA code. Super easy to
Here's a copy of my database file for this Tip:
AddToComboBox.zip (ACCDB Access 2007/2010 Format).
You may want to read these articles from the 599CD News: