In this episode, we give an example of how to add rows to a combo box while using a form in MS Access. We’ll add double-click functionality to a combo box for VBA code, which will ask for a user input that will then be added as a selection in the combo box. This technique is handy when you need to quickly add selections to a drop down without going back to design view. Related Videos: How to Make a Search Form with Combo Boxes in MS Access https://www.youtube.com/watch?v=uq3cgaHF6fc How to Make Cascading Combo Boxes in MS Access https://www.youtube.com/watch?v=at0uaGSnUco Bound vs. Unbound Forms and Controls in Microsoft Access https://www.youtube.com/watch?v=l75GsjduJuA How to Make a Listbox in MS Access Part 2: Multi-select https://www.youtube.com/watch?v=CUQj0IUE4zU How to Create In and Out Listboxes in Microsoft Access https://www.youtube.com/watch?v=46Z7paS0l3k How to Make a Multi-Term Search Form and Report in MS Access https://www.youtube.com/watch?v=yFCBWH8YHjk How to Use Timers to Run Actions or Code on an Interval in Microsoft Access https://www.youtube.com/watch?v=PeKRtRuJ1IE How to Use Before Update in Microsoft Access https://www.youtube.com/watch?v=JFYH7mmoR_s How to Make Changes to Text in a Textbox in Microsoft Access Using SelStart and SelText https://www.youtube.com/watch?v=q_tkXgsIjv4 How to Add Combo Box Rows On-The-Fly in MS Access You are watching this video now! How to Run Code as Your MS Access Form Opens - On Open, On Load, and On Current https://www.youtube.com/watch?v=KdR1LVt3VJc How to Use On Close and On Unload with Microsoft Access Forms https://www.youtube.com/watch?v=Rqhlr6NwUu8 Follow us on social media: https://www.facebook.com/mackenziedataanalytics https://twitter.com/seamacke https://www.instagram.com/seamacke/ https://www.reddit.com/user/seamacke https://www.linkedin.com/in/psmackenzie/ Get Microsoft Office including Access: https://click.linksynergy.com/fs-bin/click?id=BdGJecFFM8A&offerid=1160033.10004289&type=3&subid=0 Got a YouTube Channel? I use TubeBuddy, it is awesome. Give it a try: https://www.tubebuddy.com/seanmackenziedataengineering MS Access Project? Contact me today! Check out some of my earlier videos on MS Access: "How to Use Functions in MS Access Queries": https://www.youtube.com/watch?v=i9W1Abkg5cs “MS Access Option Groups - How to Use Radio Buttons”: https://www.youtube.com/watch?v=eg4RUEsPPiw "How to simulate Lag and Lead Window Functions" : https://www.youtube.com/watch?v=9iSuI3dR75o “How to Format Dates in MS Access Queries, Forms, and VBA Code” : https://www.youtube.com/watch?v=TaohJxP0-MI "VBA Mod Function with DoEvents: Prevent Not Responding Messages and Provide Feedback on Access Forms ": https://www.youtube.com/watch?v=BPT-_H1ir6k "Iif, If Then Else, and Select Case in MS Access" : https://www.youtube.com/watch?v=E5HbVmxHxSQ "How to Query the Last Row in a Series in Microsoft Access": https://www.youtube.com/watch?v=5cnwHyn4dnI "How to Make Cascading Combo Boxes in MS Access": https://www.youtube.com/watch?v=at0uaGSnUco "How to Open a RecordSet in Access VBA and Loop Through the Records" https://www.youtube.com/watch?v=7HckYjH_wg4