combo box populating text fields (1 Viewer)

[kdt]

Hi All

Been having trouble setting up a combo box in a form that displays data from the same line in the table into a text box.

I am trying this with a memo field without any luck. I am using a 2 column query for the combo box, the first column contains the name and the second contains the requirements (memo).

I have put in the after update code:

Private Sub CustName_AfterUpdate()

Me!CustReq = Me![CustName].Column(2)

End Sub

Can anyone please shed light on what I'm doing wrong?

Thanks

 

[pbaldy]

Column is zero based, so the second column would be 1.

 

[RV]

Column numbering starts at 0 (zero)

Try

Me.CustReq = Me.CustName.Column(1)

RV

 

[kdt]

phew, got it now, I'd stupidly not changed the column count from 1 to 2. Thanks for all your help