Automatically update field

[Top Fuel Friday]

Running Access 07'



Building a QA database and my form has 5 fields, each with 2 values (Pass & Fail)

I would like to have a form automatically fill in a 6th field with a pass or fail value based on the other five. If none of the 5 are fails then it will report a passed audit, if one or more of the 5 categories are fails than it will report a fail.

I know I can throw in the field for our auditors to complete, but I'd rather have it do it automatically as a fail safe.

Can I do this?

[pkstormy]

In an event for a field (or on every Pass/Fail) field, you could add some vba code like such:

if me.Field1.value = "Pass" and me.Field2.value = "Pass" and me.Field3.value = "Pass" and me.Field4.value = "Pass" and me.Field5.value = "Pass" then me.OtherField.value = "Pass" else me.OtherField.value = "Fail"

and you could have this code in each of Field1 through Field5 afterupdate events.

[Top Fuel Friday]

Access tells me that it cant find the object if me.

[SteveH2508]

In a text box put the following expression as the control source

(untested aircode) assuming your Fields are Yes/No fields

=IIf(Abs([Field1]+[Field2]+[Field3]+[Field4]+[Field5])=5,"Pass","Fail")