Solved

Access form auto Scroling- annoying

Posted on 2014-04-19
5
289 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 49

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 49

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 49

Expert Comment

by:Gustav Brock
ID: 40010712
You are welcome!

/gustav
0

Featured Post

Threat Intelligence Starter Resources

Integrating threat intelligence can be challenging, and not all companies are ready. These resources can help you build awareness and prepare for defense.

Join & Write a Comment

Using Word 2013, I was experiencing some incredible lag when typing.  Here's what worked for me....
In this article we discuss how to recover the missing Outlook 2011 for Mac data like Emails and Contacts manually.
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …
Learn how to make your own table of contents in Microsoft Word using paragraph styles and the automatic table of contents tool. We'll be using the paragraph styles in Word’s Home toolbar to help you create a table of contents. Type out your initial …

758 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

Need Help in Real-Time?

Connect with top rated Experts

21 Experts available now in Live!

Get 1:1 Help Now