After update to update multiple fields?

[ZBKAI189]

In advance, forgive me =) My database tracks equipment quality assurance inspections. Each piece of equipment has a unique ID as well as a part number, serial number, and a noun. Equipment information is stored in Tbl1 (information changes regularly). The inspection results are stored in Tbl2. Tbl2 data is viewed via Form1 which imports equipment info from Tbl1 and stores it in Tbl2. Currently, Form1 contains a ComboBox for the unique ID (from Tbl1) which then updates the part number field (also Tbl1) via After Update VBA. The problem is, I want the After Update code to update part number, serial number, and noun but can only get it to update the part number field. Help? My current code is as followsrivate Sub ID_AfterUpdate()
Me.PN = Me.ID.Column(1)
Me.SN = Me.ID.Column(2)
Me.Noun = Me.ID.Column(3)
End Sub

 

[pbaldy]

Make sure the combo rowsource includes all 3, the column count property of the combo is correct, and remember that the column property is zero based, so 1 is the second column.

 

[ZBKAI189]

Make sure the combo rowsource includes all 3, the column count property of the combo is correct, and remember that the column property is zero based, so 1 is the second column.

The row source includes all 3, and I did figure out that the column property is zero based... thumbs up on those two.

What do you mean by "...the count property is correct..."?

 

[pbaldy]

There is a column count property. If it is 2, then any reference to a third column will fail.

 

[ZBKAI189]

There is a column count property. If it is 2, then any reference to a third column will fail.

Haha... fixed. Thanks!

I'll be back =)

 

[pbaldy]

No problem, and welcome to the site by the way!