Auto Update text box on data sheet form

R

Robert Raley

Access 2003.

I have a data sheet form that we use to paste data into one of the fields is
[conv].

what I would like to do to have another field that is [pay_rate] which is a
text box with this formula or similar {pay_rate:
IIf([conv]>=0.15,"1250","900")} which when data is pasted into the records
puts the correct pay rate into the field [pay_rate]

Please help I am more than a little lost.

Regards
Bob
 
Top