Position Number Not Real Value

  • Thread starter Thread starter S.Galinsky
  • Start date Start date
S

S.Galinsky

Hi,

A fairly easy questions for advanced users (hopefully):

There are two tables. One contains "services" (for example "reg.
check-up","maintenaince" etc") with according prices. The other table
contains all customer informations (name, address, etc.).

Now I have created a form to fill in all the data. There is a combo/select
box to choose a "service". Another datafield is automatically filled with
the correct price of the service. Now I would like to do a simply
calculation "price*amount". The problem is that price shows the correct
value, but uses the position number of the select box to calculate.

For example you can select:
10 Euro
20 Euro
30 Euro

If you select 10 Euro the calculation is: "1*amount"
If you select 30 Euro the calculation is: "3*amount"

Obviously that's not what I need ? Is there something I have to add or click
to use the real integer value ?!
 
Can you provide more detailed information e.g. the
RowSourceSQL for the comboBox, the code that automatically
fills in the price and the code that is not providing the
correct answer.

Many thanks
Gerald Stanley MCSD
 
Back
Top