FindRecord for Max Date

Topic

New Reply

Hello,
I am opening my form with a table as a record source. The table is currently sorted on a field that means the latest entry may not be the last record. I would like to either use DoCmd.FindRecord or a temporary sort on date.
I have tried:
DoCmd.FindRecord max([GIAuditDate]), , , , , acAll
and
DoCmd.FindRecord “max([GIAuditDate])”, , , , , acAll

For many reasons I would prefer not to create a recordset, but I may need to.
I am using Access 97.

Thank you for your help.

Reply | Quote

Replies

It’s not clear to me whether you want to see all the records or just the maximum date record. Nonetheless …

Instead of basing the form on the table, have you tried basing the form on a query for that table, sorted by date descending? This would show all the records in the order you want.

If you really wanted just the maximum date record, post back .

Reply | Quote