• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 311
  • Last Modified:

Access form auto Scroling- annoying

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
Rayne
Asked:
Rayne
  • 3
  • 2
1 Solution
 
Gustav BrockCIOCommented:
It will not do that except if you have some code that performs a requery of the form.
Double-check that.

/gustav
0
 
RayneAuthor Commented:
yes it does requery,,so is it possible to do the requery and then come back to the same scrolling position?
0
 
Gustav BrockCIOCommented:
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
 
RayneAuthor Commented:
thanks
0
 
Gustav BrockCIOCommented:
You are welcome!

/gustav
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: Python 3 Fundamentals

This course will teach participants about installing and configuring Python, syntax, importing, statements, types, strings, booleans, files, lists, tuples, comprehensions, functions, and classes.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now