[AccessD] Check Box for certain status

Terri Jarus jarus at amerinet-gpo.com
Fri Mar 7 11:17:00 CST 2003


Can't you set up a Checkbox with an IF statement  like
IF Status = "Rejected" then 
   Chkbx1 = YES
Else
   Chkbx1 = NO



>>> HollisVJ at pgdp.usec.com 03/07/03 10:26AM >>>

On a report I need a checkbox to be checked if the status is Rejected. I
get the status from tblStatus, StatusID (autonumber), status, Rejected,
Canceled, Approved, etc....

How can I show a Rejected status as a checkbox instead of the word
"Rejected". They are only wanting to show the status if it is rejected.

Virginia
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://databaseadvisors.com/pipermail/accessd/attachments/20030307/fecb6d71/attachment-0001.html>


More information about the AccessD mailing list