If Then question

[Peter Paul]

I have a form which lists Case Incident Numbers Approved. Once I have compared them to a manual list, I want to be able to click a command button, and have an Audited yes/no box change to True.

My code looks like this:

If Forms!CaseCrimAudited!Approved = True Then
Forms!CaseCrimAudited!Audited = True

End If

(CaseCrimAudited is a continuous form which lists all the case incident numbers. It actually shows all the case incident numbers unless audited = True.)

The problem is that it is only changing one record at a time, I want it to change all of the records which meet the criteria with one click of the button.

Any help is always appreciated.

Thank you

Peter Paul

[This message has been edited by Peter Paul (edited 05-24-2000).]

 

[Travis]

use and Update Query to se the Audited field to True with the criteria

Approved = True and Audited = False

This way you only update the newly appoved stuff.

 

[Peter Paul]

Thanks Travis, I can always count on your help.

Peter