Check box within a form

[murphy485]

I there a way to determine whether or not my checkbox within a form is ticked or not dependant on another value within a field?

I have a field called 'DaysRemaining' and another check box field called 'Expired'. I want the expired checkbox to be ticked if the value within 'DaysRemaining' is '<0' and unticked if '>=0'. Is there a way i can do this within the control source of my check box?

Thanks, Ben

 

[catalin.petrut]

I supose that the value DaysRemaining is a calculated field. In that case, you shouldn't store that value. Even if it is not a calculated value, the checkbox is a field that is "calculated" based on the field DaysRemaining. In that case, you shouldn't store this value. In a form or in a report, where you need that checkbox, you could use it with a VBA code.