Combobox Question!!! Help

[su8z3r0]

hi, i'm a newbie, i've got a question about combobox:

i've a form "Order" and a subform "suborder" with a combobox based on a table "Object" with this value: ID, Object, Price, Category. When i choose a value, the combobox returns to the "suborder" table ID value...now, is possible to returns also the others value to that table??

Please answer me....sorry for my bad english i'm italian

Thanks early!!!

 

[wkalo]

Hi There
Could You Be More Specific Please And If You Could Attach A Sample Database So I Might Understand Your Request.

Hope I Will Be Able To Help !

Rgrds

 

[RuralGuy]

If I understand your question I believe the answer is to put some code in the AfterUpdate event of the ComboBox like:
Me.TextBox1 = Me.ComboBoxName.Column(0) ' For the 1st Column data
Me.TextBox2 = Me.ComboBoxName.Column(1) ' For the 2nd Column data
Me.TextBox3 = Me.ComboBoxName.Column(2) ' For the 3rd Column data

Using your control names of course!