Like Command Syntax Error

[Novice1]

Can I use the Like command in an If Then statement? I'm getting a syntax error

If [Primary1Name] Like 'PO*' Then

MsgBox "You cannot use a post office box address. Use a residence address.", vbOKOnly, "Incorrect Address Information"
DoCmd.GoToControl "Primary1Address1"

Else

End If

 

[plog]

Yes, but you aren't referencing Primary1Name correctly. In VBA you need to reference the control that contains that value, not the field name.

 

[Novice1]

Please explain further.

 

[plog]

Check out this thread: http://www.access-programmers.co.uk/forums/showthread.php?t=163834

Basically its this way:

Forms!FormNameHere!ControlNameHere