Confused on If, Then, Else...

[Turb]

Hi all,
I have been trying to get this statement working all morning and I'm at a loss, could someone help please?

I've this statement

    If Me.ORDTYPE.Value = PDC Then
        DoCmd.RunMacro "Macro4"
    Else
        DoCmd.RunMacro "Macro1"
    End If

under a form in my Db. What I'm trying to do is as the form is closed (or maybe updated - I've tried both) if the field "ORDTYPE" value (from a combobox on the form) is "PDC", macro4 should run, if it's not, macro1 should run.
What am I doing wrong?
Any help would be much appreciated.

-Turb

 

[Remou]

If you mean PDC as a value, you need quotes:

[tt] If Me.ORDTYPE.Value = "PDC" Then[/tt]

 

[Turb]

Geez...
I feel like such a ...

Remou, thank you very much! That did it.

-Turb