Solved

Access form auto Scroling- annoying

Posted on 2014-04-19
5
298 Views
Last Modified: 2014-04-19
Hello All,
when i enter a row via a form and hit enter, the form jumps up to first row. The form is in DataSheet view type. I dont like it goes up to the top of the row. How cani do it so that it stays where the scroll is  - any after update event?

Thank you
0
Comment
Question by:Rayne
  • 3
  • 2
5 Comments
 
LVL 50

Expert Comment

by:Gustav Brock
ID: 40010572
It will not do that except if you have some code that performs a requery of the form.
Double-check that.

/gustav
0
 

Author Comment

by:Rayne
ID: 40010574
yes it does requery,,so is it possible to do the requery and then come back to the same scrolling position?
0
 
LVL 50

Accepted Solution

by:
Gustav Brock earned 500 total points
ID: 40010591
Yes, read the ID before requerying. Then after the requery:

   With Me.Recordsetclone
   
        .FindFirst "ID = " & ID

        if .NoMatch then
            msgbox "ID value not found"
        Endif
        me.bookmark = .Bookmark

    End With

/gustav
0
 

Author Closing Comment

by:Rayne
ID: 40010605
thanks
0
 
LVL 50

Expert Comment

by:Gustav Brock
ID: 40010712
You are welcome!

/gustav
0

Featured Post

On Demand Webinar - Networking for the Cloud Era

This webinar discusses:
-Common barriers companies experience when moving to the cloud
-How SD-WAN changes the way we look at networks
-Best practices customers should employ moving forward with cloud migration
-What happens behind the scenes of SteelConnect’s one-click button

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

You need to know the location of the Office templates folder, so that when you create new templates, they are saved to that location, and thus are available for selection when creating new documents.  The steps to find the Templates folder path are …
In Part II of this series, I will discuss how to identify all open instances of Excel and enumerate the workbooks, spreadsheets, and named ranges within each of those instances.
What’s inside an Access Desktop Database. Will look at the basic interface, Navigation Pane (Database Container), Tables, Queries, Forms, Report, Macro’s, and VBA code.
In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.

679 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question