Microsoft Access Tutorial Combo Box Automation Add New Items Not In List

http://www.myaccessprogram.com/Tutorial.html - This demonstration shows working code to automate the adding of new items on a drop down list when they are not found on the list. The code demonstrates how to detect when the item the user is trying to enter is not on the list. The code then gets the user's permission to add the item and take the user to a form where the item is entered for the person. When the user closes the form, the user is taken back to the combo box (drop down list) which has been refreshed and the newly added item has been selected. An example files are available which work in versions of Microsoft Access 97, 2000, 2002, 2007.
MyAccessProgram.com

Category:

Education

Tags:

• combobox
• Not In List
• Access
• refresh list
• lookup table
• not on list
• combo box
• Microsoft Access
• add to combo box

[aantubes]

I though that you will share the code freely :)

btw, great video, just in the right time of my deadline. Thank!

[beatboxbabe]

So, tell me something, I have a list of data about students/parents/governs/other ect.. I have validation rules for a topic and a target audience.. the target audience in coded. I want to make a drop down box, with each different coded.. P,S,ST ect. How might I go about doing this?