Auto fill fields based on combo box selection

[Piperlynne]

I need help with having a form display the values in certain fields from a
table based on a combo box.
I have a form based on tblProject.
On the form, I have a combo box that looks at the Brand Name field in
tblBrand to find values for user to select to populate the Brand Name in the
tblProject. The combobox is named cboBrand.

In tblBrand - there are 3 fields - UnitType, MasterType, DateCoding that I
want to display when the user selects a Brand Name.
I have tried using cboBrand.Column(1) etc, but I'm pretty sure I'm missing
something.

 

[Arvin Meyer MVP]

The column index is zero (0) based. The 3 field must be included in the
combo box, even if you didn't want to see them, so typically you'd have the
following fields in the combo with their widths set like:

BrandID 0"
BrandName 1.5"
UnitType 0"
MasterType 0"
DateCoding 0"

your column count would be 5

To refer to UnitType, your code in the AfterUpdate event of the combo would
look like:

Me.txtWhatever = Me.cboBrand(2)

 

[Chegu Tom]

Also be sure that your combobox recordsource query has all the fields you
need

 

[Piperlynne]

Great, thanks!
One question.
In the after update piece, would I repeat that string for each textbox I
want filled in?
I can get the first box (Unit) to work right now, but I can't get the others
to fill in.

 

[Arvin Meyer MVP]

Yes. If they are in the order below, Master would look like:

Me.MasterType = Me.cboBrand(3)

and DateCoding:

Me.DateCoding = Me.cboBrand(4)

 

[kodyleonard]

Here's a little more detail on the steps:

http://bluescreensolutions.blogspot.com/2012/05/access-auto-populate-fields-in-form.html