if statements

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am working in access forms. i do not know how to use the if statements, i know what i want but it will not work in the form i have set up. if you could give me an example of an if statements or the bes way to use an if statement please do so. i have been working on this if statement for 2 wks now, i need help
 
There's your standard If...Then statement used in code

If x = y Then
MsgBox "Winner"
Else
MsgBox "Not A Winner"
End If

There's your immediate if function used in expressions

=IIf(x=y,"Winner","Not A Winner")

Check out the Access help files. There is very detailed
information and examples on both of these. Try posting
the specific code you're having trouble with and I'm sure
someone will debug it for you. good luck.
-----Original Message-----
I am working in access forms. i do not know how to use
Click to expand...
the if statements, i know what i want but it will not work
in the form i have set up. if you could give me an
example of an if statements or the bes way to use an if
statement please do so. i have been working on this if
statement for 2 wks now, i need help.
 
Back
Top