If then Elseif then....

[Thompyt]

I want to have three choices to pass allow the colsue of another field:

Approved, Denied, or withdrawn. Is the below close to being correct?


If Me!Final_VOTE <> "Approved" Then


ElseIf Me!Final_VOTE <> "Denied" Then
ElseIf Me!Final_VOTE <> "Withdrawn" Then
Action_Complete = False
Else
MsgBox "Final Vote cannot be Pending"
Exit Sub
End If

Thanks

[June7]

Why so complicated?

If Me!Final_VOTE = "Pending" Then
MsgBox "Final Vote cannot be Pending"
Me!Action_Complete = False
End If

Why are users allowed to input Pending in the first place? Use a combobox with limited choices.

Action_Complete looks like redundant field. This determination can be evaluated from the data in Final_VOTE. A Date_Complete would be more informative.

[Thompyt]

Good point. I can limit the list with no edits.

[Thompyt]

Action_Complete looks like redundant field. This determination can be evaluated from the data in Final_VOTE.

Action_Complete is the final close out of the record. It is used as a switch. Most likely I could simplify it.