capture date

[Guest]

In my forms Event I capture the person deleting a record with this:
Criteria = lCriteria & "tblTrackingData.TR_AOR, " & """" & gcurrentuser &
"""" & " AS tUser "

Could you please show me how to capture the date (todays date)..

thank you

 

[Guest]

Check out both the DATE and NOW variables in Access help
You may also want to look at the DATEPART function

-Dorian

 

[Guest]

I am familiar with DATE,NOW and DATEPART, I was not real clear on why I'm
asking for help, let me explane:
When someone deletes a record my code writes the record data to a table.
The source code table does not have a date veriable but I created one on the
new table the data is written to. If I add the DATE() for example, this
changes everytime it's run. I need to capture a date the moment the record
is written to the new table...

Can you please help?
Thanks