Drop Down menu

  • Thread starter Thread starter Nathan
  • Start date Start date
N

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
 
Nathan said:
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
Click to expand...


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)
 
Back
Top