Combo Box to allow other entries to be displayed

[PST]

Hi,
I am trying to choose an entry from a COmbo Box which ahas a Lookuop underlying in it. I then want to display the additonal four entries in the form it self. The data is already created and displayed in a query. The primary key gets displayed but thte other data cannot be displayed. Is there any way I can display the other details eg: Firstname, Surname Age in the same form but under different fieldnames. I am not sure how to do this.
I could retype it all in but that is uneconomical. Any ideas? Please help.
Thanks.

 

[ShaneMan]

Hey PST,

Yes, you can do this. In the cboBox the first column probably is your bound column and it's the one displaying. If you would like to see the other four on the form, let's say in their own individual text boxes, then you could place four unbound text boxes on the form, then in the cboBox AfterUpdate event you could put this:

Me.TextBox1 = Me.cboBox.Column(1)
Me.TextBox2 = Me.cboBox.Column(2)
Me.TextBox3 = Me.cboBox.Column(3)
Me.TextBox4 = Me.cboBox.Column(4)

The column count starts at 0, so column 1 is actually 0 and so on.

HTH,
Shane

 

[PST]

Thanks Shane - I will give this a go.