View Single Post
  #3  
Old May 5th, 2010, 10:40 AM posted to microsoft.public.access.forms
neil40[_2_]
external usenet poster
 
Posts: 28
Default Open Continuous form with a few lines showing

On 5 May, 02:16, "Arvin Meyer [MVP]" wrote:
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, MVPhttp://www.datastrat.comhttp://www.accessmvp.comhttp://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- Hide quoted text -


- Show quoted text -


I'll give it a try Arvin, but not quite what I want.
I like the whole set of data being available to me in the continuous
form, and wanted the 'new' line to appear with a few 'old' lines
ideally.
I can certainly scroll if necessary, to check where I left off, but if
it could be 'automatic' that would be better.

I presuming that your solution only returns the lst 5 records?

Neil