In Access, I Created a Macro with:
Condition: [Forms]![frmContacts]![NewRecord]=True
Action: SetValue
Arguments: [Forms]![frmContacts]![RecAdded],=Date()
The Condition part seems to work as desired, but when it is true, the field [RecAdded] is set to "12:00:10 AM".
I want to record the date a new record was added to the database, and would very much appreciate help in getting this problem resolved.
Condition: [Forms]![frmContacts]![NewRecord]=True
Action: SetValue
Arguments: [Forms]![frmContacts]![RecAdded],=Date()
The Condition part seems to work as desired, but when it is true, the field [RecAdded] is set to "12:00:10 AM".
I want to record the date a new record was added to the database, and would very much appreciate help in getting this problem resolved.