Sub-Form help

[Jay]

I have a sub-form which is big enough to show 8 records, but the underlying
source query often returns more records.
Is there any way I can force the sub-form to open with already scrolled down
so it shows the 8 most recent records, rather than the first 8 records?

Any help greatly appreciated.....Regards, Jason

 

[chriske911]

I have a sub-form which is big enough to show 8 records, but the

underlying
source query often returns more records.
Is there any way I can force the sub-form to open with already
scrolled down
so it shows the 8 most recent records, rather than the first 8
records?
Any help greatly appreciated.....Regards, Jason

I'd try sorting on a field that shows you the most recent fields
you can define this sorting in your query or on the form

grtz