MS Access table modified date [RESOLVED]

[jtnelso]

I am trying to get the table modified (or creation) date of a table in Access. I am pulling in sales data and storing current sales in a table, which is overwritten with new sales the next day. On the form I display the sales numbers, I need to show when the sales were last updated. I could get this information dynamically from the sales table's creation/modified date property; however, I cannot find a way that works for me.

Ideally, I want the code that gets this information to run during the Form_Load() event.

Any thoughts?

[Issvar]

CurrentDb.TableDefs("MyTableName").DateCreated
CurrentDb.TableDefs("MyTableName").LastUpdated

[jtnelso]

That worked perfectly...thanks for your help, Issvar.