URGENT Combo-box

[mapat]

Hello,

I have a Stock table with fields "StockDescription" and "StockPrice"
I created a combo box to display all the "StockDescriptions" on a form.
Now, once I select one description from the combo box, I want its correspondant StockPrice to show on any text box which I created on the same form and this is what I don't know how to do. How would I do this in ACCESS??

I'd really appreciate it if anyone would guide me throuhg this asap

Thank you very much in advance

 

[Moniker]

If your drop down is in the order you pointed out (Stock Description, Stock Price), then your textbox control source is this:

=ComboBoxName.Column(1)