some help would be awsome!!

[StupidStudent]

Wicked forum have learned alot using these pages however......

I have a table which holds a product name and price. On a form i have a combo box which has 2 columns 1 for the product name and 1 for the price. Next to the combo box i also have a text box which i would also like to display the product price.. is there any way of selecting a product from the combo box and the price appering in the text box???

any help would be Awsome thanks !!!!!

 

[Dennisk]

use the column property of the combo box.
in you control set the source to
=me!yourCombobox.column where n is the number of the column.

 

[GaryPanic]

answered this yeterday for someone else

look at the attached (not the flash form)
and see the code behnd the combo after update

 

[StupidStudent]

Thank you both so much you guys would not believe how long i have spent trying to sort that part out thanks again!!!