View Full Version : Adding a field to a table that will automatically prefill


CChampagne
05-28-2008, 10:55 AM
Does anyone know if there is a way to add a field to my Table that I can format do automatically prefill the current date as the date the user entered the record? If so, how??? Thanks

Pat Hartman
05-28-2008, 11:02 AM
There are two places you can specify default values - In the table definition itself and in forms.

I generally use the table default for something like this. Just put:
Date()
in the default for the field. If you want the date and time, use:
Now()

CChampagne
05-28-2008, 11:38 AM
Thanks Pat, that's exactly what I needed.