Changing the default value

[LabRatz]

I have a db for payroll. Each payroll run I enter all the data for 200 employees. The period end date and check date are the same for everyone so I set the default values on those two date fields before entering the data. My question is: Is there a way to use another form (or VBA code) to change the default value for those two date fields on the Input Form for the current dates? I don't want to have to enter the dates over and over, but don't want the person I'm training to go into the "properties" to change the default value for those date fields. Any help would be greatly appreciated.

[pbaldy]

You can try this:

http://www.mvps.org/access/forms/frm0012.htm

[LabRatz]

For that to work do I have to create a command button on my form and put that code on the command button? Or is this supposed to go in the default value field of the properties of the date field?

[pbaldy]

I believe it's commonly put in the after update event of the control.

[LabRatz]

Great, thanks. I'll try that