If varable Then

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Andre' L. Micheaux - 09 Mar 2005 18:48 GMT

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

Reply to this Message

Dirk Goldgar - 09 Mar 2005 20:03 GMT

> I have a record that is either yes or no (-1 or 0).
>
[quoted text clipped - 11 lines]
> Thanks
> Andre' L. Micheaux

I'm not entirely sure what you are asking. The code block you posted,

> IF rstItem!prj Then
> code
> End If

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.

Signature

Dirk Goldgar, MS Access MVP
www.datagnostics.com

(please reply to the newsgroup)

Reply to this Message