Auto Fill a date in a field

[SJJ]

Hello:

I am new to using ACCESS and would really appreciate some help. I have a database that has several tables which generate forms for my office to print for client files. I have these forms set to print based on a query that will only pull the ones that have a form printed field not selected, if that makes sense. What I would like to add is a field right next to the form printed field that allows us to enter the date the form was printed. I have added this field but now would like to take it a step further and have the date automatically fill once the form printed field is checked. I hope this makes sense. Thanks in advance for your help.

SJJ

[ItsMe]

Place VBA code in the afterupdate event for your form printed field.

If me.[form printed field].value = -1 then
me.NameOfDateField.Value = Date
end if