If varable Then

  • Thread starter Thread starter Andre' L. Micheaux
  • Start date Start date
A

Andre' L. Micheaux

I have a record that is either yes or no (-1 or 0).

The statement is

IF rstItem!prj Then
code
End If

What does this do or where can I find the answer.

Prior to this I have rstItem = currentdb....(Select IIF(Project =
"",No,YES), more code, AS prj

Thanks
Andre' L. Micheaux
 
Andre' L. Micheaux said:
I have a record that is either yes or no (-1 or 0).

The statement is

IF rstItem!prj Then
code
End If

What does this do or where can I find the answer.

Prior to this I have rstItem = currentdb....(Select IIF(Project =
"",No,YES), more code, AS prj

Thanks
Andre' L. Micheaux
Click to expand...

I'm not entirely sure what you are asking. The code block you posted,
IF rstItem!prj Then
code
End If
Click to expand...

will execute the series of statements represented as "code" if
rstItem!prj evaluates as any non-zero value, and will bypass those
statements if rsItem!prj evaluates to zero. If rstItem!prj is -1,
"code" will be executed. If rstItem!prj is 0, "code" will not be
executed.
 
Back
Top