26Jul/113
Access 2007 Tutorial 5.4. Inserting into multiple fields using a Combo box and NotInList Event
You can work along with this file:
database-with-forms.accdb
Code can be found at the end of the post.
In this video:
- On Not In List event
- Variables & Constants
- msgbox()
- if-else statement
- Arrays
- Split()
- DoCMD.RunSQL
- UBound()
- Remaining Issues
When I teach my Access course, I often get students who feel that entering information into the database should be easier than it is, even with forms. Well, we can make it easier, but it usually requires some programming to do some work on behalf of the user. The more work we do, the less work the user has to do.