How do you have the date enter when a check box is selected?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

soccerwood14 - 18 May 2005 23:24 GMT

I am creating a database and I want when someone clicks on a check box for it
to enter the date in another field and I don't want that date to change
unless the check box is un-selected

Reply to this Message

Dennis - 19 May 2005 08:45 GMT

in the after update event of the checkbox put the following code

if CheckBox = True then
OtherField = Date()
Else
OtherField = ""
End if

> I am creating a database and I want when someone clicks on a check box for it
> to enter the date in another field and I don't want that date to change
> unless the check box is un-selected

Reply to this Message

soccerwood14 - 19 May 2005 15:35 GMT

I am going to try this code, but I think the date will change from day to
day, but hopefully it will not I will have to wait and see what happens
tomorrow.

> in the after update event of the checkbox put the following code
>
[quoted text clipped - 7 lines]
> > to enter the date in another field and I don't want that date to change
> > unless the check box is un-selected

Reply to this Message