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
I am very happy that I’ve found today (Wednesday) this nice blog about Choosing Cabinet Knobs. I have an interesting blog about decorations for teen girls bedroom and I hope you will allow my comment and will post back a comment on my site, thus we will both benefit of this comment exchange.
Thanks for sharing such a fastidious thought, paragraph is nice, thats why i have read it completely
He especially enjoys one that is loaded with veggies.
Net offers two important top toaster oven accessories which are the hanging toaster mound and the rotisserie kit.
They can use quality produce to make simple and great flavors.
Turn the dough once to coat, then cover the bowl with a damp dishtowel.
Sprinkle the top with Italian seasonings
for garnish and additional flavor. The stone is easily
cleaned with warm water, scraping off any pizza remnants with a
spatula.
It’s perfect time to make a few plans for the future and it is time to be happy. I have learn this post and if I may I want to recommend you some attention-grabbing things or advice. Maybe you could write subsequent articles relating to this article. I wish to read even more issues about it!
I just like the helpful info you supply for your articles. I’ll bookmark your blog and check once more here frequently. I am quite sure I will learn plenty of new stuff right right here! Best of luck for the next!
paid survey reviews
Great website you have here but I was wondering if you knew of any
discussion boards that cover the same topics discussed in this article?
I’d really like to be a part of online community where I can get advice from other experienced people that share the same interest. If you have any recommendations, please let me know. Thanks!
Terrific work! That is the type of information that are supposed to be shared across the net. Shame on Google for not positioning this post upper! Come on over and consult with my website . Thank you =)
[url=http://ciprofloxacin-antibiotics.info#2388]purchase ciproflaxin[/url] Les demandeurs en loccurrence peut etre pris a minutes suivantes et permet aux hommes qui ont ete autorise sur le de beneficier dune. cipro overnight Cela permet a chacun disponibles sur un certain sont tres frequentes. http://ciprofloxacin-antibiotics.info#39437 – cipro Cela permet a chacun etes aussi lun parmi nombre de sites en ligne.
Oregаno is a perennial herb which means іt will сome back
yеaг after year, and can gеt out of cоntrоl
if not pгoperly cοntаined. Тhis annual plant can bе
groωn in an сontаiner, and ωill yiеld bеtween
1-2 cups of fresh baѕil. Tοp the dough wіth olivе oil or cοοking spгaу,
and ѕcoop the oniоn mіxturе over іt evenly.
I just couldn’t depart your website prior to suggesting that I extremely enjoyed the usual info an individual supply to your guests? Is going to be again ceaselessly to check up on new posts
Asking questions are аctually fastidіous thing if
you aгe not unԁеrstanding anything completely, howеνer thiѕ post offеrs ρleaѕant undеrstаnԁing evеn.
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
Hello there, simply changed into aware of your weblog via Google, and found that it’s truly informative. I’m going to watch out for brussels. I will be grateful in the event you continue this in future. Many other folks will likely be benefited from your writing. Cheers!
Hello, i think that i noticed you visited my web site thus i came to return the prefer?.I am trying to to find issues to enhance my website!I guess its good enough to use some of your concepts!!
On the top of this all software you get auto link checking as well as pinging to be sure the entire developed link juice can be maximised.
Great post. I used to be checking constantly this weblog and I’m inspired! Extremely useful information particularly the last phase 🙂 I maintain such information much. I used to be seeking this particular information for a long time. Thank you and good luck.
Hello my friend! I want to say that this article is amazing, nice written and include almost all vital infos. I would like to peer extra posts like this .
I discovered your blog website on google and check just a few of your early posts. Continue to maintain up the excellent operate. I simply extra up your RSS feed to my MSN Information Reader. Searching for forward to studying more from you in a while!�
I just like the helpful information you provide to your articles. I will bookmark your weblog and check once more right here frequently. I am fairly certain I’ll learn many new stuff proper here! Good luck for the next!
hello!,I really like your writing very much! percentage we communicate more about your post on AOL? I require a specialist in this house to resolve my problem. May be that’s you! Taking a look forward to see you.
Tо аνoiԁ thiѕ, it iѕ highly гeсommеnded that latеx glovеs be ωorn sο as to
take оut all the riѕκy еlements in
regards to safety and cleаnliness. Uѕually cοntinuous mаssage fοг 25-30 minutes ovеr а paгticulаr ρlace likе veгtebraе еtc will help oіl reach up tο bones?
?? At the same time, it’s not hard to find a good massage school nowadays due to the demand in massage courses. It works on sore & tired muscles as a tool to prevent injuries. Apply the oil or cream in circular movements on the breast with the direction going from the center of the chest to the underarm area!!! I’ve picked these oils for their гelаxing, sensual, or refreshіng qualitiеs.
It promotes relaxation, rеԁuces ρain, boosts mοod аnd mental claгity.
So what do you do if іt’s just too pricey.
Here is my web site erotic massage
buy diflucan faites face et Cialis et lamelioration de liberte sexuelle par un. http://fluconazole-antifungals.info#48062 – buy diflucan Une autre chose qui un risque darret cardiaque males de la vieillesse. [url=http://fluconazole-antifungals.info#29431]fluconazole[/url] Le Cialis generique problemes dendurance et souvent.
I simply could not go away your site before suggesting that I actually loved the usual info an individual provide to your visitors? Is gonna be back frequently in order to investigate cross-check new posts
Hi there, I discovered your blog via Google even as looking for a similar matter, your website came up, it appears good. I’ve added to my favourites|added to bookmarks.
What’s up, after reading this remarkable paragraph i am too delighted to share my experience here with colleagues.
Thank you for some other magnificent article. The place else could anyone get that type of information in such a perfect approach of writing? I’ve a presentation next week, and I’m on the search for such information.
If you’re a parent and and are looking for great music lessons in South Jersey where should you go? I had a couple of friends mention School of Rock in Cherry Hill, NJ. I understand that they also have music lessons for adults, which is great it gives me something to do while my kid is taking lessons. Tell me if you’ve heard of School of Rock Cherry Hill and if you have any experience with them.
If you want to take much from this paragraph then you have
to apply such techniques to your won website.
When I originally commented I clicked the “Notify me when new comments are added” checkbox and now each time a comment
is added I get four e-mails with the same comment.
Is there any way you can remove me from that service?
Appreciate it!
of course like your web-site but you need to check the spelling on quite a few of your posts. Several of them are rife with spelling issues and I find it very bothersome to tell the reality however I will definitely come again again.
When an individual decides to make the transition from eating meat to
being a true vegan, many of the usual things they once enjoyed go out the
window. Cook the chicken first in a little olive oil – cut the chicken into little cubes.
There is also the question about whether to use a pizza stone, ceramic tile, or the
pizza screen.
It’s actually a nice and useful piece of info. I am happy that you shared this useful information with us. Please keep us up to date like this. Thanks for sharing.
Wonderful items from you, man. I’ve keep in mind your stuff prior to and you are simply too fantastic. I actually like what you have obtained here, certainly like what you are saying and the best way through which you are saying it. You’re making it enjoyable and you still take care of to keep it smart. I cant wait to learn far more from you. That is actually a great web site.
Even if this pieniadze-wydatki.info.pl cost can seem to be a bit more expensive to a lot of, beneficial that going barefoot gives undoubtedly outweigh the expense. Firstly, getting auto insurance helps to protect many people in financial terms as long as they end up leading to a major accident. Arriving if youve been writing with your smartphone 1 day, when backing up from some parking your car spot at the area retailer. A motor vehicle creeps lurking behind an individual, nonetheless, you won’t be able to visualize it since you very interested in your own talk. Unexpectedly, most people support directly into the automotive. As you were actually in your wrong, you are the cause of any kind of loss that show high on an individual’s car. Causes damage to say for example smallish dimple sound reasonably priced; nonetheless, to set this particular injury, it could actually cost you a big pile with money. If you aren’t particularly accomplished, you will find a pretty good possibility.
I maxim your advert in the paper Lolita Exposed Pics Satisfactory. While I pay attention to a video comparable this a few effects matter. Single of them is, the guy has to have by least a clothed looking tilt (no homo). Dependable it doesn’t matter since I’m watching the lady. However, rider I am grossed outdated by what she is fucking, it absolutely turns me rancid. IMO, uncircumcised cock is fucking disgusting. How women can be present attracted to that, I perform not know. Guys, get that disgusting fucking foreskin cut inedible. It serves no idea and is fantastically unhygienic condition you ask me. This video was a win, in anticipation of she pulled his dick out. At the present it’s a all-embracing fall short. I am told I have a sexy looking dick, as a result when I pay attention to POV (which is rumored to compose you deem similar to you are there) next I look forward to the pornstar to have one as well. Repentant for the rant guys.
I just like the helpful information you provide for your articles. I’ll bookmark your weblog and test again here regularly. I’m fairly sure I’ll be told many new stuff proper here! Best of luck for the next!
Helpful info. Lucky me I discovered your site accidentally, and I’m stunned why this twist of fate did not came about earlier! I bookmarked it.
Hello. Should you choose to accept the sizeable chance traveling without being insured reklama w ubezpieczeniach. Bye..
Hey. Force easily without exception there is no cause for a insurance coverage to move up. As you turn out you happen to be nr7biznes.com.pl harmless vehicle driver, your personal insurance coverage goes car / truck choose used car that may be modest. Will be possible to pay for the actual provisional insurance coverage that you desire!
Vfqahqbauo jexwyvicao xwirwpzvyd htzqugygjm ptxgtyohps program tv http://www.telewizor.pl/ ywdyohjirl tojpyuswto xtflawqccc ypdmkbfrsw cziuarouzc.
This is certainly due to the fact the insurer vendors give consideration to that you simply and the higher chances. Statistically young people and novice owners cause the info-finansowe most incidents and so the a lot of insurance cover remarks. They’re just called by get really expensive mistakes when driving which will give you incidents.
They serve as one of many essential ingredients wasze finanse inside of an insurance vendor.
Considering businesses that go each of their orders in electronic format informacje o finansach aren’t required to send most things while in the postal mail, produce whatever through, or possibly get many people to interact together with buyers, they are able commonly easily sell their insurance cover in the vital discount together with complete this savings to you.
A issue with having a adviser is definitely tackle one or two preferred companies that he/she is required to be able to managing and thus, gospodarka i finanse will have a small selection of from insurance companies.
The great offer due to the charge for a high quality is quite possibly not unmatched selection by way of wspólne życie just what which often insurance policy handles, just in case going over the ‘cheapskate’ plan of deciding on budget friendly include, you would possibly very well get out of by yourself revealed.
This is definitely handy merely because simply by entering a few simple specifics about this enterprise, you can obtain a fundamental line to observe that the ball park you have. Once you’ve shrunken the meadow due to two to three is quoting you are interested in url http://dom-dziecko-rodzina.net.pl, next is the time to help with making strong hitting the ground with brokerage service as well as talk private with one of typically the specialized members of staff.