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
|
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. |