Hi All,

I started a project that seemed simple enough at first, but has since spiraled out of control. I'm looking to automate one of our processes by using the value of one field to determine another.

Firstly, I'm using Access 2007. What I want to do is figure out a field called "placement" from a student's test scores. That part was difficult but I figured it out. The next thing I want to do, I'm getting stuck on. I want to now calculate an assessment value field based on placement. For example, if placement is 100, assessment value should be 50. My problem is, the only events that will allow the assessment value field to populate are "on click" and "lost focus".

I don't want to have to go through all the records and click on placement in order to populate assessment value. That would defeat the purpose, since I plan to import the test scores that placement is based on in the first place. I want the form to populate the table and not vice versa. Is there any way to do this? Thanks in advance!