Sub-Form help

J

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
 
C

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
Click to expand...

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
 
Top