Validation Rules

[spindar]

I have a question about validation rules.

I have in my db field called approved by which is the name of the manager approving the results, now what I wish to do is have the validation rule work in two ways

(1) Only the manager logged in can approve results, this is so that the managers can not use another name to approve work.

and

(2) In the table where the data is stored I have a field called analysed by. This has to be different from the manager who approves the work.

so far I have got them both to work separately but not together.

for 1 I use =currentuser()

for 2 I use <>[Analysed By]

How do I combine both of these rules?

Any help is greatly appreciated

tnx

 

[WayneRyan]

spindar,


If (CurrentUser() = [Approved By]) And _
(CurrentUser() <> [Analysed By]) Then
MsgBox("OK")
Else
MsgBox("Not OK")
End If

Wayne