Drop Down menu

[Nathan]

I have a drop down menu on my main form, it gets it data
from another table, in that table i have 3 colums, ID
Item and price(number) the menu reads the data from item.

what i need is so that in the main form when a value from
the dropdown menu is selected, i can get the data from
price to be calculated with other information in a text
field

eg
item price
i year license 50

Form
if i select toy
my text field would get the price * qty

 

[Marshall Barton]

I have a drop down menu on my main form, it gets it data
from another table, in that table i have 3 colums, ID
Item and price(number) the menu reads the data from item.

what i need is so that in the main form when a value from
the dropdown menu is selected, i can get the data from
price to be calculated with other information in a text
field

eg
item price
i year license 50

Form
if i select toy
my text field would get the price * qty

You can retrieve the value of any column in a combo (or
List) box by using the Column property. E.g.

Amount = Me.Price * Me.combo.Column(2)