Results 1 to 2 of 2
  1. #1
    Lounger
    Join Date
    Dec 2000
    Location
    Ohio, USA
    Posts
    28
    Thanks
    0
    Thanked 0 Times in 0 Posts

    FindRecord for Max Date

    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.

  2. #2
    3 Star Lounger
    Join Date
    Dec 2000
    Location
    USA
    Posts
    379
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: FindRecord for Max Date

    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 .

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •