see last 'n' records on screen, but don't sub-set data

[NJS]

Hi All,
On an Access detail form, when the user enters a record it is added to the
bottom of the list (which is too long for the form), and only the first 'n'
records are visible.
How does one see last 'n' records on screen, without sub-setting the data.
The user needs to be able to scroll up if necessary
thank you.

 

[Mike Painter]

Hi All,
On an Access detail form, when the user enters a record it is added
to the bottom of the list (which is too long for the form), and only
the first 'n' records are visible.
How does one see last 'n' records on screen, without sub-setting the
data. The user needs to be able to scroll up if necessary
thank you.

Sort the dataset in reverse order is probably the easiest way.
If you don't have a numeric key or an existing date field, you might add an
indexed key and set it to a default of Now() which will sort on date and
time.

 

[KARL DEWEY]

UNTESTED UNTESTED
Try AfterUpdate or AfterInsert event call macro for GoToRecord - Record -
Last and see if that will do it.

 

[NJS]

Thanks people. Unfortunately the client wants data sorted ASC. and want a
full screen - I was hoping to use the scroll method but don't know how.