Trying to get table to give a value based on a calculation

[accessnewb24]

I'm trying to create a database that has one field that automatically gets filled with a value based on a calculation made from other values input by the user. If the calculation is above a specific value I want the database to say "Fail", otherwise "Pass". My goal is to create a form that a user can easily input numbers into, then have a "pass" or "fail" value displayed on the form as well as saved into the database table itself. I was wondering what the best way to go about this was. I accomplished it by using a query based form but I don't know how to get the query to add new values to the table.

[June7]

Use an UPDATE action query. Are there multiple records in that table? In VBA would be like:

CurrentDb.Execute "UPDATE fieldname = '" & something that calculates PASS or FAIL text value & "' WHERE somefield =" & some criteria

Is this a multi-user split database?

[accessnewb24]

There are multiple records and when it is finished it will be a multi-user database.So with that piece of code, could I essentially insert a button on the form that will update the table and refresh the data?

[accessnewb24]

I made a very simple version of what I want to do. The sum of 2 numbers input would give a "Pass" value if it's positive and "Fail" if negative

[June7]

Since the field is in the form RecordSource, don't even need UPDATE action, simply:

Me!Logic = something

Real trick is figuring out what event to put code into.

Actually, usually best NOT to save dependent (calculated) data.

Don't even need to save PASS/FAIL into table - it can be calculated when need.

So, an expression in query or textbox: IIf([Calculation]<0, "FAIL", IIf([Calculation]>=0, "PASS", "No Data"))