recordset created date/time

[questionit]

I am trying to use DateCreated property of RecordSet but getting error.

Set db = CurrentDb

Set rst = db.OpenRecordse t("SELECT name FROM Table1")

If i try:

While rst.EOF = False
MsgBox rst.DateCreated () <- i get error here
rst.MoveNext
'Wend

Error: Operation is not supported for this type of object

How can i fix the error and how can i see the record created date

Thanks

Qi

[Rabbit]

DateCreated only works on a table-like recordset. It only gives a date for the entire table, not record by record. If you want to do it record by record you have to program an auditing table to keep track of any changes you make. This of course will only keep track of changes made after the implementation and will not keep track if the user bypasses the code, such as if they go to the table directly to enter records.