I have a form similar to this?

Form Header
JOB# 672 Job Name Bid Deal Week Ending 12/12/00

Details
RECNum--Name--TC-H-Rate
--------------------------
Rec# 1 Bob Vain OT 6 $5.00
Rec# 2 Jim Hush ST 7 $6.00
Rec# 3 Tim Grim DT 4 $7.00

Then I set a conditional macro like this:
Condition [TC]="ST" SetValue [Rate]*1 RepaintObject
Condition [TC]="OT" SetValue [Rate]*1.5 RepaintObject
Condition [TC]="DT" SetValue [Rate]*2 RepaintObject


The problem is that all records are being updated based on the record that I am in when I trigger the macro. So if I am in rec#1 and run the macro #2 and #3 use whatever #1 equals. How do I update each record based on the information in that record.


[This message has been edited by Talismanic (edited 06-08-2000).]

What version of Access are you using?

If you are using Access 97 or older then I'm sorry to tell you this but a change in Formating/ControlSource and the like effects all records. The way to get around this is to only have a single record view. (This way you don't see the change in the other records) and have your condition happen on the on open of the form.

Access 2000 on the other hand can handle Format changes per record. (I have not tested changing the controlsource of a field but I think it can handle this also).

Hope this helps.

I am using Access 97 but I do have 2000 installed on my machine. The only reason I didnt buid it in 2000 is because all of the users will be 97. If I split the database can the users use it with a 97 front end? Or do I need to get additional 2000 licenses.