forcing a checkbox to be true if another field os false

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

Guest

Hello,

I am rather new to Access so any help would be much appreciated.

On a form, I have a checkbox titled "Warranty?" If it is under warranty, I
check it; if its not, I leave it blank.

Now, on a report, I have a section that states "Warranty" with two check
boxes; one for Yes and one for No. I would like to set it up so when the
report prints, and the original Warranty check box in the form is NOT
checked, I want the "No" box automatically checked on the report, by the
report.

I think it acn be done with an expression, but am not sure how.

again, any help would be appreciated.

Thanks,

Richard
 
Richard said:
On a form, I have a checkbox titled "Warranty?" If it is under warranty, I
check it; if its not, I leave it blank.

Now, on a report, I have a section that states "Warranty" with two check
boxes; one for Yes and one for No. I would like to set it up so when the
report prints, and the original Warranty check box in the form is NOT
checked, I want the "No" box automatically checked on the report, by the
report.

I think it acn be done with an expression, but am not sure how.
Click to expand...


It doesn't matter what's on the form, a report is determined
by its Record Source table/query. I think you mean that
your table has a Yes/No field named Warranty.

If so, then you can bind the report's Yes check box to the
field in the normal way. The No check box can use the
expression:

=Not Warranty
 
Back
Top