I am having a problem with fields auto-updating with a linked table value.

I have it working on one, but when I try to link a second field to the same table, it doesnt automatically fill-in the value.


Table has columns A, B, and C and form has boxes for A, B, and C info. When choosing value A from the drop down list, field B auto populates the value from Column B of the table.

Private Sub A_AfterUpdate()
1     Form_InputForm.B = A.Column(1)
This works perfectly for A and B.

What I cant do is populate value C on the form from the table column C.

Damn, I even managed to confuzzle myself!

Any thoughts?