Access 2010: Auto populate fields using a combo box in forms.

This video shows how to create a form that uses a combo box to populate other fields in the form based on the selection from the combo box. The process uses some basic VBA programming to do the job.

[@epic1654]

10 years after uploading this, it still works flawlessly! Thank you, Allen! :)

[@Myron0506]

This is the only tutorial I found that worked. I could find other ways to auto populate the form fields, but the auto populated fields don't get entered into the table. But this works like a charm. Thank you!

[@Crtaj]

I was searching for this almost two days, I can't describe how thankful I am.

[@phiwwie]

FOR THE LIFE I could not find a video that explained how to manipulate values on multiple tables via a calculation and thanks to this video I was able to piece it together. You're the MAN!!!

[@nancylalicon4192]

This was the most clear tutorial on this topic! Thanks!

[@GhenadieRosca]

This is my first time ever successful code!!! I am so happy! Thank you so much!!

[@ticoguy05]

Allen, this is by far one of the best and easiest explanations on here. Thank you and cheers from Costa Rica.

[@gator98bcn53]

I have been looking all over to figure out how to do this. Thank you for posting. Easy to follow.

[@kristianotaku8543]

5 years later and your still a legend man, well done

[@johnallred6038]

Exactly what I was looking for, presented clearly and succinctly. Thanks!

[@wheat1buck]

Your presentation was clear, concise and easy to follow. Thanks much for your time and effort. It will be an asset for many who follow!

[@Drlbrown]

Most helpful video I have watched on this yet! Thank you!

[@SoonerDiscGuy]

Thank You. I needed this to help with a form I created a few years back. Your visual was spot on. Have a super day, Larry

[@karthim5701]

The best easy to follow instructions. Like everyone else you saved me a lot of unnecessary work. Thank you so much and please make more tutorials

[@parmeshkumarperiyaswamy1043]

I am a Access Programmer but after a long time I am going to kick off again. This was a great help to me. - Thanks.

[@denisea3465]

I have been searching for this for a very long time. Excellent - thank you so much!

[@przemektube]

Concise, to the point and straightforward. Thank you!

[@DAcutech]

Thank you very much for solving one of the most contentious problems I have been facing. Much appreciated.

[@Tangerinka410]

Took me a while to find the proper expression to google what I actually want to do, but this it IT and very well explained! Thanks!!!

Many thanks sir ... You're indeed a lifesaver for an access beginner like me .. Great job helping us out :)

[@kingjames379]

Very helpful. Short video with very nice explanation. Please keep posting such videos...

[@MeAlone44]

You are my Hero, I have been looking for this longer than I would like to admit. THANK YOU!

[@zakhill-whilton3345]

You are so brilliant! I honestly tried a lot of times using this video before it ended up working, but I got it, and it feels awesome. Thanks for posting this -- my boss is going to be really happy!!!

[@happycoconut11]

Thank you very much! I tried other codes lines that did not work for me. Your method finally helped me solve the problem I had. Your help is much appreciated.

[@Tash98]

You'll forever be the dope access dude I found on KZbin

[@lawrencepasierb7993]

Thanks for the help! I got stumped on a form I was doing and your tut came up,,, very precise and helpful!

[@mouadbelfakir2978]

Thank you sir, you did what many others failed to do.

[@Geekvangelist]

The exact information I needed. Big thumbs up. Thanks a lot for the tutorial!

[@jsphschmtt]

you just saved me a ton of time. this is exactly what I needed. Great tutorial.

[@christophergaley3734]

I have been looking for this info for a while. Thank you very much.

[@Ivan-ry7vm]

Thank you for your tutorial, it worked form me. I read some of the criticism. I think that the point you were trying to show us is very clear, the content of the tables is not important. Don't be discouraged by few negative opinions.

[@robertclarke5537]

I have been trying relational combobox to solve this issue, no such luck. Thanks for this post. This will work perfect with my Training register. Thanks much

[@devkamal7705]

thank you man . Maker of access in Microsoft & its founder shall go to heavens.

[@c.j.visscher4793]

Thank you for this clear instruction on updating fields in a form based on a combo

[@walterbell1146]

I tried all the steps in the video and it works very well. Thanks a lot ;)

[@matthill5890]

This is exactly what I needed for my project. Thank you very much!

[@arlettevangurp]

THANK YOU SOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOO MUCH! It was so hard finding a solution for this! Thank you for posting!

[@TheologicalQuest]

Thank you for this video... it was very helpful in setting up an auto-populating combo box in Access 2013. I have several other programs I use for designing data entry interfaces and they all have an option built in to make it very easy to do this (I don't understand why Access doesn't), but you were very helpful.

[@iliyanakuneva6227]

The most clear and helpful tutorial of them all :) Thank you!

[@jayprayag]

Thank you so much. You educated an old man. God bless you!

[@Mofongo2024]

Thank you! Been looking for help with this. This has helped me a lot. Thanks for explaining it so clearly.

[@Smosherable]

Very useful. Exactly when I had given up on using Macros to do this simple task. Thanks !

[@MikeRadoiu]

Thanks Allen, it works perfectly for me!

[@spikencina]

Great !!!! Easy informative and better tips than my college class !!!!

[@F1ashingblade]

Thankyou, an excellent video. You've answered what I've been searching for perfectly.

[@angiejacks9933]

Thank you for this! I've been trying to figure that out for a while!

[@hansdampf7397]

Thank you! That's what I searched for.

[@ElDespertar]

This has been of a great help. Thanks a MILLION!!!

[@RungeCarl]

Great explanation for what is a fundamental in Access

[@DonDufresne]

Thanks for a great tutorial. I appreciate your effort.

[@efreddy6868]

Great job! Very easy to follow and it worked very well - even in a Split Form.

[@عمرصابر-ن8ط]

ɷ Heeeey Friendss I Have Founddddd Workingg Online Hacck visitttt : - t.co/vOFsUFqOI7

[@deepaksahtani5830]

You are a life saver, I had tried dlookup but it was always throwing error, Thanks!

[@rass8428]

EXACTLY what I was looking for, thank you!

[@yonatansaputra5986]

THANKYOU SO MUCH !!!! THE BEST TUTORIAL EVER.

[@UCanDoIt2Mike]

Very clear explanation. Many Thanks!!!!

[@zuesking1974]

Thank you just what i was looking for to copy info from combo box into other fields in form.

[@manchesterroyal]

Awesome video....just what I needed.....saved me hours.....thank you so much.

[@frankcampagna4138]

This is an awesome tip. Not only does it save time in data entry, it also ensures accuracy of the data. Thanks.

[@jackiewilcock]

I did it in the end took out the control source became unbound and worked. Thank You

[@frederickrunge6284]

Really helpful! I will be keeping an eye out for other hints. Thank you!

[@jloo1900]

Very clear. Thank you and God bless you with desires of your heart.

[@sarahm195]

Thank you so much! Very easy to follow and a huge help to me.

[@Timberwolfer21]

Great tutorial. Very easy to follow.

[@julienne1098]

thank you so much man! ill be using this for my undergrad thesis

[@ferrocarrill34]

Great explanation atj049! Gracias!!

[@Manic3DF]

Thank you so much for this tutorial, really well made. :)

[@amberlofthouse114]

thank you thank you thank you this video is so easy to follow and finally was able to do what i wanted to do !!!!

[@whoismariomeraz]

Excellent video, kind sir.

[@MrRicodav]

Thank you for this! I was stuck trying to use a synchronized combo box to do the same thing.

[@wpbasics]

Great job my friend. This video helped me out a lot. Thanks!!!

[@kurts2775]

Awesome!!!! This helped so much!! Thank you!!!!!!

[@alicecolyar424]

Excellent presentation. Many thank yous!

[@Thefinegansflorida]

freaking amazing. Thank you so much. very specific in your details. Thanks for posting

[@jiyu_han4210]

Thank u so much for this tutorial...u just save my life.. Finally my assignment already finished😂

[@megancao9250]

awesome tip, such an easy way to solve my problem!

[@RUNAWAY-shepherd]

Great video and very helpful. Thank you!

[@mannysilva1194]

Great Video!! Thank you so much for sharing.

[@martinbradburn1140]

Excellent tutorial.

[@pgprodj]

Thank you for your time. This helped me ALOT!

[@chrispretorius85]

Thanks a million man, this is spot on!

[@Fantic1980]

EXACTLY what I was after, thank you so much sir!

[@mattg1489]

Literally was about to off myself~ You saved my life! (I know a little dramatic, but hey... this was that life saving)

[@sguadalajara]

Thanks great tutorial help me allot easy to understand and follow

[@rocknrose99]

I can't thank you enough I needed this so badly

[@user-ue3pk6sz3i]

Fantastic. I am so annoyed exploring it and finally after watching this thank God. Problem solved.

[@denysuhendraproject5251]

Thank you for the longlasting knowledge, even this day your video still useful for other people. I hope you have a great day, I dont know whether you still know your own KZbin Account or not though lol

[@esanariam]

Thank You, Finally I've found the one I have been looking for.

[@tianyu1061]

Very helpful video!

[@thebigexegete]

this is great stuff. do you have any lessons on how to add a drill down feature for a field, text box, etc.?

[@AnandaAberathne]

thanks for clear explanation

[@gerardmullan7222]

Thanks. Great explanation.

[@FatimaH-nr4qx]

Thank u so much, this video helps me a lot

[@ugb25]

You made my day !!! Thank you, great tutorial !!! :-)

[@simom8708]

Thanks so much, very useful

[@jamiewhite102]

Very good video! Thank you so much!

[@rmatene]

Excellent!!! Great Job

[@DrivetoSuccess13]

Thanks man it help me a lot.

[@wahyudisaputra4362]

thanks for your clear tutorial

[@AmjadAli-taha]

Thanks a lot dear! great Job!

[@MrRwebb1983]

Thank you so much! This really helped!