Auto fill Date when Yes/No field is True

[jenfish7871]

I'm having a problem in Access 2010. I have only been using Access about 6 months and know nothing about programming VBA or SQL code. I have looked through the Macros and Expressions but I'm not very good with those yet and haven't found anything that looks like what I want.

I have a table with a "Closed" Yes/No field and a "Date Closed" field. I would like the "Date Closed" field to auto fill the date when a user selects the "Closed" field as True.

Any help is greatly appreciated!

 

[bob fitz]

I would suggest that you could do this with a couple of lines of code in the After Update event of the Yes/No field.