Looking up a price for a job....

[sonata2002]

Hello there...

I have a table with two fields - "job title" and "job description". In the table there is data, such as "web0001" as the title with a corresponding price, such as "50".

Simple enough...

However, in my form when i select the correct item in the "job title" field, i want Access to AUTOMATICALLY insert the corresponding price in my "price" field in my form...

Any ideas...?!?!

Thank you very much in advance!

[This message has been edited by sonata2002 (edited 05-01-2002).]

 

[David R]

http://www.access-programmers.co.uk/ubb/Forum2/HTML/001605.html

 

[sonata2002]

This now works, using the ComboName.Column(1) control...

however, one problem remains...!!

My form now correctly looks up the values of the price from a column as shown above, however, when i then try and calculate the prices to get a total, rather than adding them together, it puts them in front of one another..

E.g. if my prices were "50", "100" and "50", rather than adding them to make a total of "200", it shows the total as "5010050"....

Any ideas how i can add this correctly..>?

 

[nicktheblue]

Hello sonata2002,

make sure that the format of the field you are copying the price into is set to some kind of number format ie. long integer and not text. I think that should solve the problem?

Or perhaps the formula you are using to add the figures together needs tweaking.

HTH

Nick

[This message has been edited by nicktheblue (edited 05-02-2002).]

 

[sonata2002]

Well,

the text box is definitely formatted to be a number, but it STILL does the following:

E.g. if my prices were "50", "100" and "50", rather than adding them to make a total of "200", it shows the total as "5010050"....

all im doing is adding the value fields together to get a total...

Any ideas...??

[This message has been edited by sonata2002 (edited 05-04-2002).]