How to get two information from one combo box at once?

[Anna Anna]

Hi!
I created ‘Sales Form’. At this moment I have Combo Box to choose ‘Product Name’ and another Combo Box to choose ‘Price’. These two Combo Boxes have two columns each showing ‘product name’ and ‘price’.
To enter ‘product name’ I click first one and choose from column with ‘products name’ and to enter ‘price’ I choose from column showing ‘price’ beside product name. Both combo boxes are linked to the same Table.
My question is: Is this possible to have only one combo box, and after choosing ‘product name’ have the corresponding ‘price’ put automatically to the filed ‘price’?
That improvement would save a lot of time when entering hundreds records at a time.
Thanks for any ideas in advance.
Anna

 

[Mile-O]

If you leave the combobox unbound and put two textboxes on your form and make them hidden then:

in the afterupdate event of your combobox you can assign the values to the textboxes.

i.e

txtHiddenTextBox1 = cboYourCombo.Column(0)
txtHiddenTextBox2 = cboYourCombo.Column(1)

 

[Anna Anna]

Thanks for your quick respond. It looks good, but unfortunately
I will be able to try this late tonight or tommorow. I can't wait.
Thanks again and I will let you know how it works.
Anna

 

[Anna Anna]

Hi Mile-O-Phile!!!!!
I just tried it. It works just PERFECT.
Thank you so much.
Anna