Change the form's underlying record source to a Top 5 query.

In a query's design view, right click in a blank area, and choose
properties. Set the Top Values to 5, then adjust your criteria and order by
clause to return the records you want. Use that query as your form's record
source.
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.accessmvp.com
http://www.mvps.org/access


"neil40" wrote in message
...
Hi

I have successfully implemented a continuous form to open at a new
line with
RunCommand acCmdRecordsGoToNew
in the Load Event

However, you have to manually scroll a little to see a few of the
previous records.
It would be nice to see up to 5 of these previous lines on Opening the
form

Is there a way to modify this code to do that?

Thanks
Neil