update a field during run time

[manoskok]

I have a form which displays data from a specific query.

What I need is to have an extra field on that form (calculated field but I don't need the value to be strored), which will show a specific value depending on the previous field
(the previous field may have 10 different values)

Is it possible ?

I tried the iif statement but i did't succeed.

Please help

 

[GingerR]

IIF should work.
send your statement.

 

[manoskok]

Dear GingerR
Thanks a lot for your message.

I have tried the iif statement and works fine for 2 options.
My problem though is more complicated :

During the recording of the data I have 20 different types of food which is easy to select from a combo box and then the data is stored in the food-analysis table.

The problem is that I have a customers table with different cost for each food type and different cost for each customer.

What I am trying to do is to have a form, from which I could select the data I want and then some how to automatically find out who is the customer, what is the cost for each food type and estimate the total cost.
(so far I managed to succeed to find the customer for the specific data).


Any suggestions ? (Could a case statement be helpful)
Thanks a lot in advace.