check box

[Guest]

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

 

[Garret]

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

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

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

 

[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

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])