Check for last record

  • Thread starter Thread starter Jeff
  • Start date Start date
J

Jeff

I have a form with a subform and I would like to check for the last record
I tryed If Me.CurrentRecord = Me.Recordset.RecordCount but it only brings
back what is curently in the sub form. I would like to check all the recrods.
How would i do that?
 
Not exactly sure what you're looking for, but maybe
Recordset.AbsolutePosition would work in place of Me.CurrentRecord

hth
--
Jack Leach
www.tristatemachine.com

"I haven''t failed, I''ve found ten thousand ways that don''t work."
-Thomas Edison (1847-1931)
 
Hi Jack,
This brings back the position that you are in on the Sub Form. I am looking
to see if I am at the last record in the table and not just the last record
in the sub form. Thanks!
 
Tables don't have an order... the only way to do this is to log the date/time
it was created/modified, and run a SELECT TOP 1 query descending by the
date/time field.


--
Jack Leach
www.tristatemachine.com

"I haven''t failed, I''ve found ten thousand ways that don''t work."
-Thomas Edison (1847-1931)
 
Back
Top