Displaying other fields linked to a lookup field

[mwgo]

I have a table that contains a lookup field to another table. This selects the Primary key (just an autonumber)
How would I go about selecting the other fields in the lookup field related to the primary key selected and placing them in other boxes on the screen?

thanks

 

[KevinM]

You will have to do this in vb on a form and reference each column.

e.g. Say you had two text boxes on a form and you wanted the second column in the combobox selected stotred in TextBox1 and the third in TextBox2...

MyCombo_AfterUpdate()

TextBox1=MyCombo.Column(1)
TextBox2=MyCombo.Column(2)
End Sub

Note Column(0) is the first Column in the combobox.

HtH

Kevin M