open with last records (1 Viewer)

[jonwentz]

hi, all

Is there any way to tell a tabular form to display the last 31 records when it is opened


thanks in advance
jon

 

[WayneRyan]

Jon,

It's kind of vague as to what "the last 31 records" means.

If you mean chronologically, have a date/time stamp, and sort on that
descending.

Or, you can sort the form, by an AutoNumber Descending.

If you need ONLY 31, look at the TOP predicate for your SQL query.

Wayne