Check for last record

[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?

 

[Jack Leach]

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)

 

[Jeff]

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!

 

[Jack Leach]

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)