Remain on current record after requery

Discussion in 'Microsoft Office' started by siwilsonchan, May 15, 2018.

  1. siwilsonchan

    siwilsonchan

    Joined:
    May 15, 2018
    Likes Received:
    0
    Hello,

    I know almost nothing about programming, but I really need some help with what I am trying to do.

    I've been trying to figure out how to do this for a couple of days now. I tried searching through this forum, but I just can't seem to be able to apply the methods discussed here to my work.

    I am trying to add a command box in which I could requery my record. I was able to accomplish this by typing "me.requery" under build event. However, whenever I click on the command box, the record refreshes, but it goes back to the first record. How do I requery but stay on the current record?

    Thanks for your time,

    Wilson
     

    Attached Files:

    siwilsonchan, May 15, 2018
    #1
    1. Advertisements

  2. siwilsonchan

    Abraham Andres Luna

    Joined:
    Mar 14, 2018
    Likes Received:
    47
    Location:
    Spring Hill, FL 34608
    Can you add code to the button click event to remember the current record, and then after the requery it selects the current record?
     
    Abraham Andres Luna, May 16, 2018
    #2
    1. Advertisements

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.