Another "IF" PROBLEM

[osullipa]

Can anyone please tell me what I am doing wrong with the following statement?

If Me.qpwd.Value = BROWN THEN
...
... ETC.


I have tried putting "BROWN" in quotes / parenthesis etc but cannot find the correct syntax.

Thanks in advance.

Peter

 

[ColinEssex]

You need quotes is its testing for a string value.

Where exactly is this code?

Col

 

[osullipa]

You need quotes is its testing for a string value.

Where exactly is this code?

Col

I thought it needed quotes, but thought maybe something else as well. Yes it is testing for a string.

Peter

 

[osullipa]

I thought it needed quotes, but thought maybe something else as well. Yes it is testing for a string.

Peter

Forgot to say it is in the code for a LogIn button which checks the user name and password on an entry form then opens the next form if both are correct.

Peter

 

[Brianwarnock]

If Me.gpwd = "Brown" Then ..

Brian