check box

J

Jbcrtilla

I would like to add a check box to a form that automatically enters a tick if
a "return date" has been entered on the form. Can anyone help me please.
Many thanks
 
G

Garret

Jbcrtilla said:
I would like to add a check box to a form that automatically enters a tick if
a "return date" has been entered on the form. Can anyone help me please.
Many thanks
Click to expand...

In the BeforeUpdate event of your return date field, do:

If Not IsNull([ReturnDate]) then
[Checkbox].value = 1
End if
 
F

fredg

I would like to add a check box to a form that automatically enters a tick if
a "return date" has been entered on the form. Can anyone help me please.
Many thanks
Click to expand...

First you need to add a Yes/No Check box field to your table, then add
it to your form.

On the form, code the [ReturnDate] AfterUpdate event:
Me![CheckBoxField] = Not IsNull([ReturnDate])
 
Top