I'm Stuck

[snagrat]

I have a form with a combo box which has two columns.

Also on the form is a text box whose control source is "Price"

When the combo box is opened it displays a productID and the price.

When the required item is clicked I wish the price text box to update so it shows the price value also in the combo box.

How is this possible? I have done it using a price combo box but this is not what I want.

Any help would be great.

 

[KevinM]

In the combo's after update event....

[PriceTextBoxName]=[ComboBoxName].Column(1).

Column 1 being the second column, all combos & list box columns start at 0.

 

[The_Doc_Man]

Alternative: If the name of the control matches the name of field supplying the second column of the combo box, update is supposed to be more or less automagic.

Or at least it used to be.

 

[KevinM]

That's a new one on me, must be in a later version, maybe Access XP (which I don't use).