Discussion on:

Automatically fill in Access text boxes based on a combo box selection

Something that I read when I started with access which has stood me in good stead.

Never unless it REALLY does not matter leave labels and controls with their default names such as Combo 17 or text 6.

What is Combo 17 or text 12?

rename your controls with a name that identifies the contol such as cmbNameLookUp. and Text 12 as txtFirstName

When you have dozens of controls it makes all the difference and if someone has to come after you and tweak your VBA they will bless you rather than curse you.

Cheers - Alan

That's one of my favorite tricks on forms that only need a few fields updated from a combo. It takes a lot less code than looping throug a recordset for each text box or using a dlookup for each.

I think it's also faster than the above mentioned methods, although I may be fancying that since I think this trick is clever

Thanks for the post.
Lisa

This process comes to a screeching halt at Step 7 in Access 2000, where I am looking at a Combo Box Wizard with two list boxes (Available Fields and Selected Fields), and I can not select more than one field at a time in the Available Fields box, but can only add all fields at once, or individual fields one at a time, to the Selected Fields text box.

I can probably find a work-around, but it would be so helpful if an "Applicable Versions:" or "Applies To:"
line were included at the top of the article.