How to auto fill fields in access (2010) based on combo box selection

Published by Shane-Zentz

How to auto fill fields in access (2010) based on combo box selection

by Shane Zentz

Access is a great program for small level databases. The kind of databases and programs that almost every small business today needs. And of course Microsoft makes it very easy for almost anyone to create a complete database driven solution. Simple order entry database programs are very common in todays business, and Microsoft Access makes it possible to create a viable solution reasonably quickly, efficiently, and economically. Access contains a number of features that make it the database application of choice for small businesses today. One of those features is the combo box. This tool allows the end-user to simply select an item from a drop down menu, instead of having to type it in manually. A real time saver. But from the programming and database designer point of view, they can sometimes be a little difficult and frustrating to work with. So this article is about what I have learned in working with these combo boxes, and how to succeed in your next Access project by using these handy tools.

For this article I will start with a simple and very basic table that looks like the following:
ID (autonumber primary key), Customer (text), Address (text), City (text), State (text), Zip Code (text). This is obviously a simple customer database which will hold typical customer data. The kind of data that a lot of small businesses would have and would need to store in an efficient and easy way. I am not going to go over how to create the tables in access as that is a little below the level of this article. But check out google for many articles on how to create basic tables and basic databases in any version of Access. So we assume that we have our customer table in place. And we can also assume that we have some arbitrary amount of (valid) data inserted into the table.

This data will be useful for many purposes to most small businesses. However in an effort to increase efficiency and also accuracy, it would be nice for the end-user of this database to be able to just search for the customers name and then all of the data related to that particular customer would then be displayed in the correct fields. This is possible with access and combo boxes. In fact there are at least two ways of doing this. The harder way and the easier way. The harder way involves adding some simple code to the combo boxes ‘after update’ property. Usually something like TextBox151=ComboBox9.Column(2). This method certainly works, but there is an even easier (and cleaner) method of accomplishing this with no code at all. So now we know what we want, we want to auto fill fields of a form or report based on the value chosen by the end user in a combo box. Read on to learn the easy way to achieve this.

Recall that we have our simple ‘Customer’ table and that it is filled with some kind of data (even test data is fine). So what we want is a form that will display that data. This is very easy in Access, but we want more. We want a combo box that will only display the customers name, and when the end user selects a certain customers name the rest of the data for that customer (address, city, state, etc.) will automatically fill the fields of the form. So here is the easy way to do this. The tricky way. First open the customer table (in this case, your table will probably be named differently) in datasheet view. With this table open, go to the ‘Create’ tab. Now on the ‘Create’ tab, you have three choices for creating a form (or possibly even more). But the first choice simply says ‘form’. This is the one that we want.

So select this choice and you will see Access will create a neat looking form that has every field of the table (Customer, in this case) that was used to create it. Now you can close out the customer table. Go to the form that Access created when you clicked on the ‘form’ button. Switch to design view. Try to make some room somewhere on the form to add the combo box. Then select the combo box tool on the ‘Design’ tab and place the combo box somewhere on this form.

 

A wizard will open. If you have added combo boxes in other places you will notice that if you use this method of adding a combo box, now you have a third option of where to get the data for the combo box from. And this new option (the bottom one) which says something like “Find a record on my form based on the value I selected from combo box”, is exactly the one that we want.

So select that and choose something logical to fill the combo box, in this case I would choose Customer (the name of the customer, to make it easy for the end user to find who they are looking for). Now save the form and switch back to form view. Test it out. You should see that when you select a customers name, then their corresponding data is automatically filled in to the other fields of the form. Like magic.

If this has not worked for you, then you have probably missed a step listed above. The most important things are to make sure that Access makes a form for you based on the table that you want to pull the data from, and that you choose the third option in the combo box wizard (the one that says something like “Find a record on my form based on the value I selected from combo box”. If these steps are followed then your form should be autofillingout itself based on the end users choice in the combo box. Now what you do with this data and this form are up to you. And remember that this is only one method of accomplishing this little bit of magic. If this does not work for you or does not suit your needs, then I would recomend trying the method which involves adding a bit of code to the ‘after update’ event on the combo box. A little more difficult, but still pretty easy. Anyway thanks for reading this Access tutorial and article.

Shane Zentz

1,166 thoughts on “How to auto fill fields in access (2010) based on combo box selection”

  1. Excellent post. I was checking constantly this blog and I’m inspired! Extremely useful info specifically the final section 🙂 I handle such information much. I was seeking this particular info for a very lengthy time. Thank you and best of luck.

  2. I think this is one of the so a great deal considerable in rank for me. In addition to i am jovial evaluation your article. However wanna commentary on a number of collective possessions, The site liking is perfect, the articles is really careful . Emphatically acceptably activity, cheers.

  3. 個人の印は印と[url=http://www.harumishop.com/]銀行印[/url] いう以外、その内容は更に幅広くて、すべて店名、部屋館、住所、封検、詩の言葉などは含まないものはありません。形式上です 篆書は主として、その他のフォントも採用があって、特に広範に新しく出土する甲の骨、封泥、陶印、レンガ、鼎イ族、泉を採択して文字を洗います。 方為主で形を印刷して、その他の楕円はしかし、長方形なども作者に従って選びます。これに加えて作者は個性的で一様でなくて、教養の深さはそれぞれ異なっていて、それによって形成各種 異なる特徴と流派、その中は齊白石で”の大胆にも独創を要して、長い年月”の古きを捨て新しきを立てるスローガンを超えるのは最もよく響きます。清末全部で生産する青田石、色は青を主として、黄、白くて、淡緑色で、薄くて緑で、黒くて褐色で、赤いオーソがあります。青田石初期と盛んな化石 名声を等しくして、生産高は寿[url=http://www.harumishop.com/]銀行印[/url] 山に次いで、石質の精度はもとても大きい違いがあります。石質が丈夫で小さいのはかたくて、光沢は強くて、刻む時刀と石略作ざくざく音、 軽快な感があって、だからその時の篆刻のために材料の逸品を印刷します。その性質の最も良い者は照明のために凍って、特に清浄で、全透明。別にギンナンの青、黄色の青田、 があります白い青田、紫の青田など、皆上等な印の材料のため。清朝末期利者を追って、太い石は製造して胚を印刷して、鉄製のなべと砂を入れて怒るで炒めて、氷のひびを使用して、 それから黒色の水の中に青色のインク赤いことを入れてあるいはあるいは、色をひびに入らせて、ものともしないで“蛇の皮が凍る”と称します。しかし石一経は怒って炒めて脆くなって、[url=http://www.fusuihouin.com/]ハンコ[/url] 刻む時むいて裂けやすいです。その筋道は準備して、ペンを使って墨で刀を運んで、全て彼の書道と絵画の同一で豪放な風格。同時に中婦の人の像と陽文の青銅器の凸凹文字を印刷して、 といちばん陰文の字は皆面の“明月の前身”を印刷することと待って、同一の[url=http://www.harumishop.com/]認印[/url] テーマをめぐって展開して、それぞれ毛が生えることがあって、このを章氏の夫人の気持ちの幾重にも重なり合うカナダにしのびます 深くて、そのためとても強い芸術の感化させる能力があります。

    http://www.tjty88.com/Shownews.asp?id=227
    http://www.animeforums.smfnew.com/index.php?action=profile;u=320
    http://www.23bn-vdf.com/forums/member.php?action=profile&uid=518393

  4. My brother suggested I could possibly like this internet site. He was entirely correct. This put up definitely created my day. You cann’t visualize just how much time I had spent for this data! Thanks!

  5. cipro Cela permet a chacun de consommer cialis en qui souffre de probleme ligne. [url=http://ciprofloxacin-antibiotics.info#5173]cipro[/url] La meilleure chose a propos de cialis est quil est disponible en differentes doses de 5 des rabais considerables sur le prix de cialis la dans. http://ciprofloxacin-antibiotics.info#43561 – cipro Cela permet a chacun etes aussi lun parmi nombre de sites en de sante.

  7. I’ve been exploring for a little bit for any high quality articles or weblog posts on this sort of area . Exploring in Yahoo I eventually stumbled upon this website. Reading this info So i’m glad to convey that I’ve a very excellent uncanny feeling I came upon exactly what I needed. I most unquestionably will make sure to don?t forget this website and give it a glance regularly.

  8. I dive regularly so wear earplugs all the time. My longest lasting ones were moulded from a kit, they’re much more hygienic than foam ear plugs and last for ages. It’s far less expensive than having your earplugs moulded by a professional; I’d suggest them to anybody who uses them regularly.

  9. Amazing things here. I’m very satisfied to peer your article. Thank you a lot and I am having a look ahead to contact you. Will you please drop me a e-mail?

  10. We’re a group of volunteers and opening a brand new scheme in our community. Your web site offered us with useful information to paintings on. You have done a formidable activity and our entire group will probably be thankful to you.

  11. It’s actually a nice and helpful piece of information. I’m satisfied that you simply shared this helpful info with us. Please stay us informed like this. Thanks for sharing.

  13. Hi there very nice website!! Man .. Beautiful .. Superb .
    . I will bookmark your site and take the feeds additionally?
    I am glad to search out so many helpful info here within the post, we need develop more
    techniques in this regard, thank you for sharing.

    . . . . .

  14. I’ll immediately grasp your rss as I can’t in finding your e-mail subscription link or e-newsletter service. Do you have any? Please let me recognise so that I could subscribe. Thanks.

  16. This is really fascinating, You’re an overly professional blogger. I’ve joined your feed and stay up for in search of extra of your fantastic post. Additionally, I have shared your web site in my social networks

  19. Maybe I was wrong not reviewing How to auto fill fields in access (2010) based on combo box … in its entirely but I still stand firm researching alternative methods for collector car trader .

  20. I’m really inspired together with your writing abilities as well as with the layout on your blog. Is this a paid theme or did you customize it yourself? Anyway stay up the nice quality writing, it is uncommon to see a nice weblog like this one these days..

  21. Attractive section of content. I simply stumbled upon your site and in accession capital to claim that I get in fact loved account your blog posts. Anyway I’ll be subscribing on your augment and even I achievement you get entry to persistently quickly.

  22. Hello, i feel that i noticed you visited my web site thus i got here to go back the favor?.I am trying to to find issues to improve my web site!I assume its good enough to use a few of your concepts!!

  23. This is very attention-grabbing, You are an excessively professional blogger. I’ve joined your rss feed and look forward to seeking more of your fantastic post. Also, I have shared your web site in my social networks

  24. Your mode of telling everything in this paragraph is actually nice, all can simply understand
    it, Thanks a lot.

  25. I do consider all the concepts you have introduced on your post. They’re really convincing and will definitely work. Nonetheless, the posts are very brief for newbies. Could you please prolong them a little from next time? Thank you for the post.

  26. Turn the dough once to coat, then cover the bowl with a damp dishtowel.

    Just be sure to sprinkle the bottom with cornmeal so the pizza will slide easier and pull
    the oven rack out so you aren’t likely to get injured while sliding it onto the pizza stone. That is, until I thought about making a pizza using my cast iron skillet.

  27. Je vais certainement revenir. J’admire le temps et l’effort que vous mettez dans votre blog et des informations détaillées que vous nous offrez !

  28. I am not positively where you’re getting your information, but safe subject. I requirements to spend a number of period erudition further or thoughtful extra. Gratitude for magnificent communication I was looking on behalf of this info for my mission.

  30. You can alsο monitor yοur ѵehіclе via GPS facility.

    Υou сan also relaxation аѕsured that
    уou vehicle іs concealeԁ from unωаnted curіosity from comρеtitorѕ οr businesѕ sρiеs ‘” particularly important if you’re rасing.

    Feel free tо viѕit my page: Ebony

  32. Tactuality is alternate sound consume of mom in adjustment to for the most part break off up getting tankinis nowadays, every produced partially contrarily, We want dejection and reds and purples and blacks and greens and hereafter counsel us, golds,anyhow, actuality’s what you withstand to accede if [url=http://www.missluciya.com/category-40-plus-size-lingerie.html]Plus Size Lingerie[/url] arcade on superior pantyhose.
    It has a alight, abstruse and attenuate activity and altogether displays the estimable curves of women,00 elsewactuality, The afterwardsward all-around study bathing clothing has dependable aqua a marriage also bush via the top [url=http://www.missluciya.com/category-41-accessories.html]nipple cover[/url] rated and asable-bodied take down select that offers both of them calmly and asable-bodied blazon.
    mypluslingerie, The copiousness’s corded rope Brazilian bikinis may able-bodied every so ordinarily outclass up a behemothic accomplishment or on the accomplished damp squib because of the alone actualization deliver, You will obtaining applique stockings, get better stockings, seamed stockings, fishnet [url=http://www.missluciya.com/category-50-santa-hats.html]santa hat[/url] stockings, and abounding added.
    accumulated, the oversupply and abutment energy of bras acknowledge turn up a continued temperament in the something out 5 years as able-bodied as the [url=http://www.missluciya.com/]Adult costumes[/url] take it twenty years, aqueous acrylic is basically aqueous springy that is activated to her physique with a acrylic besom or imperturbable a breaker, bethink a lot of, if not all, abundances forbid share on panties and added duds palpitate terminated warm areas, rightly do not acquirement these items afterwards clever allocation, so it is noted to ask around barter behavior as it is best to be harmless if it appears to faculties of lingerie.
    I’ll be the contemptuous boong to accept it,It is a anatomy of lingerie that on oblige added abutment to the confederation clothes, which enhances the helpmate’s adorableness, [url=http://www.missluciya.com/category-51-ornaments.html]christmas embellishment crafts[/url] Tactuality absolutely are those cheaper ones, but they may weaken extensively afterwards two or three uses.
    I undertake to tolerate admitting, if I was indigene strange to Ardyss, I was adequately blooming if it came to gather appearancer beneathabrasion, Experts acclaim to aces lower down raiment practice sufficient sterling assets that unequivocally not accumulation execrable afteraftereffect proper for you to the bloom of your accepted delicacy, This agency that you acknowledgment [url=http://www.missluciya.com/category-1-sexy-lingerie.html]sexy lingerie[/url] it and decay time.
    http://www.123spam.de/fwd-offer/#comment-70951
    http://home-makeover.org/modern-bed-headboards/#comment-250305
    http://rcysw.com/archives/1008.html#comment-71386

  33. Thank you for the good writeup. It actually used to be a amusement account it. Look complicated to more introduced agreeable from you! By the way, how could we communicate?

  34. I’m extremely inspired with your writing skills and also with the layout for your blog. Is this a paid theme or did you customize it yourself? Anyway stay up the nice high quality writing, it is uncommon to look a great blog like this one nowadays..

  35. This is a – How to auto fill fields in access (2010) based on combo box … great tip particularly to those new to the blogosphere. Brief but very precise info… Appreciate your sharing this one. A must read post!

  36. Magnificent submit, very informative. I wonder why the other specialists of this sector don’t realize this. You should continue your writing. I am confident, you have a huge readers’ base already!|What’s Happening i am new to this, I stumbled upon this I’ve found It positively helpful and it has helped me out loads. I am hoping to give a contribution & help other users like its helped me. Great job.

  39. I have been surfing online greater than 3 hours lately, yet I by no means discovered any fascinating article like yours. It is lovely price sufficient for me. Personally, if all webmasters and bloggers made just right content material as you did, the web might be much more helpful than ever before.

  40. Fantastic goods from you, man. I’ve consider your stuff previous to and you’re simply too great. I really like what you have obtained here, certainly like what you are saying and the best way wherein you assert it. You are making it entertaining and you continue to care for to keep it sensible. I can not wait to read far more from you. That is actually a great website.

  41. Good day very cool site!! Man .. Excellent .. Amazing .. I’ll bookmark your blog and take the feeds also?I am happy to find so many useful information right here in the publish, we need work out extra strategies in this regard, thanks for sharing. . . . . .

  43. Last wishes as other AAA MMOs drop to the same fate? StarWars: The Intimate republic and [url=http://www.rmtest.com/rmt/nexonpoint.html ]nexonpoint RMT[/url]?
    With Bioware/EA making Important Wars am not so sure. Bioware has a most luxurious track journal of soothe games nothing in MMOs. EA WAGE WAR WITH EA recently announced in place of Lady Wars to be the merely privation 1 mil subs like the identical reprove thing they said for STRUGGLE am not prosperous to keep my fingers croseed in requital for it corporate monster on unexceptionally procure in the end.
    FF14 on the other handwriting I do suffer with dogma in. Made aside SE who does entertain a popular MMO at the beck their belt. [url=http://www.rmtest.com/rmt/diablo3.html ]ディアブロ3 RMT[/url] they stated was their experiment and consideration to be occupied in beta (ok that is what i called it). The new SS and videos i obtain seen, seems to be a fuse of WoW and [url=http://www.rmtest.com/rmt/latelu.html ]ラテール RMT 最安値[/url]? We shall keep company with, and I cannot wait.

  44. hi!,I really like your writing so a lot! share we keep in touch more approximately your article on AOL? I need a specialist on this space to resolve my problem. May be that is you! Looking forward to look you.

  45. Pretty component to content. I simply stumbled upon your web site and in accession capital to assert that I get in fact enjoyed account your weblog posts. Any way I will be subscribing in your augment or even I achievement you get admission to persistently quickly.

  47. Heya i’m for the primary time here. I came across this board and I to find It truly useful & it helped me out a lot. I hope to offer one thing again and aid others like you helped me.

  48. Hello Web Admin, I noticed that your On-Page SEO is is missing a few factors, for one you do not use all three H tags in your post, also I notice that you are not using bold or italics properly in your SEO optimization. On-Page SEO means more now than ever since the new Google update: Panda. No longer are backlinks and simply pinging or sending out a RSS feed the key to getting Google PageRank or Alexa Rankings, You now NEED On-Page SEO. So what is good On-Page SEO?First your keyword must appear in the title.Then it must appear in the URL.You have to optimize your keyword and make sure that it has a nice keyword density of 3-5% in your article with relevant LSI (Latent Semantic Indexing). Then you should spread all H1,H2,H3 tags in your article.Your Keyword should appear in your first paragraph and in the last sentence of the page. You should have relevant usage of Bold and italics of your keyword.There should be one internal link to a page on your blog and you should have one image with an alt tag that has your keyword….wait there’s even more Now what if i told you there was a simple WordPress plugin that does all the On-Page SEO, and automatically for you? That’s right AUTOMATICALLY, just watch this 4minute video for more information at. Seo Plugin

  49. I don’t even know how I stopped up right here, but I thought this publish used to be great. I do not realize who you’re but definitely you’re going to a well-known blogger if you happen to are not already. Cheers!

  50. obviously like your web site however you have to check the spelling on several of your posts. Many of them are rife with spelling problems and I to find it very bothersome to tell the truth nevertheless I will certainly come back again.

Comments are closed.