By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,806 Members | 1,506 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,806 IT Pros & Developers. It's quick & easy.

Displaying most recent records by default

P: n/a
Good morning,

I have a sub-form that displays records from a table as a continuous form.
The table has several hundred records, but the subform only displays five or
six records. The records do include a date field.

How can I force the sub form to display the most recent dates by default,
verses forcing the user to scroll through all of the records to the bottom
of the form in order to view the most recent entry or to add a new entry to
the table?

Thank you kindly

Tim G.
Nov 12 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
Why don't you just add to the code that opens the form(s) to go to the last
record (or new record).

DoCmd.GoToRecord acForm, "YourFormName", acNew

Wouldn't that end up displaying the last four or five records and the new,
blank record.

--
Greg Homyer

"Tim Graichen" <Tg*******@neo.rr.com> wrote in message
news:6U*******************@twister.neo.rr.com...
Good morning,

I have a sub-form that displays records from a table as a continuous form.
The table has several hundred records, but the subform only displays five or six records. The records do include a date field.

How can I force the sub form to display the most recent dates by default,
verses forcing the user to scroll through all of the records to the bottom
of the form in order to view the most recent entry or to add a new entry to the table?

Thank you kindly

Tim G.

Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.