save the date a Y/N box changed

[strods]

hey everyone,

I'm a moderate user of Access but I'm trying to iron out a problem.
I have several Y/N boxes for various status I'm trying to track. For each Y/N box I also have a date field inteded to capture today's date as the day the the Y/N box was last updated. The only problem is I do not know how to do this.

This is a church database.
The main form is called "Family Detail".
This form has a subform called "Family Members".
Family Members has several fields but two of which are:
a Y/N box called "Converted".
and a date field called "Converted Date"

P.S. I do need the seperate fields because there is a sizable proportion of the congregation that was saved before they kept good records so the check box will cover everyone and the Date field will be for going forward and those who remember.

I am trying to set it so when a user clicks on the "Converted" Y/N field, that field is checked, and the "Converted Date" field is filled in with today's date.

Your help would be appreciated.

[ADezii]

hey everyone,

I'm a moderate user of Access but I'm trying to iron out a problem.
I have several Y/N boxes for various status I'm trying to track. For each Y/N box I also have a date field inteded to capture today's date as the day the the Y/N box was last updated. The only problem is I do not know how to do this.

This is a church database.
The main form is called "Family Detail".
This form has a subform called "Family Members".
Family Members has several fields but two of which are:
a Y/N box called "Converted".
and a date field called "Converted Date"

P.S. I do need the seperate fields because there is a sizable proportion of the congregation that was saved before they kept good records so the check box will cover everyone and the Date field will be for going forward and those who remember.

I am trying to set it so when a user clicks on the "Converted" Y/N field, that field is checked, and the "Converted Date" field is filled in with today's date.

Your help would be appreciated.

Assuming your Converted Check Box is named chkConverted, and your Converted Date Field is named txtConvertedDate, then in the AfterUpdate() Event of the Converted Check Box, (chkConverted), copy and paste the following code:

If Me![chkConverted] Then
  Me![txtConvertedDate] = Date
Else
  Me![txtConvertedDate] = Null
End If