Results 1 to 2 of 2

How to move to same control of the next record

  1. #1
    sra2786 is offline Advanced Beginner
    Windows 7 64bit Access 2016
    Join Date
    Oct 2017
    Cincinnati, OH

    How to move to same control of the next record

    I want to change the value in a control and then move to the same control in the next record. How can I move to the same control of the next record when I select the Key Up and Key Down?


  2. #2
    Micron is offline Virtually Inert Person
    Windows 10 Access 2016
    Join Date
    Jun 2014
    Ontario, Canada
    See if File > Options > Client Settings > Move After Enter does what you want. It should move to the next record in the same field but I do believe that will propagate to all db's.
    Otherwise I think you're looking at a code solution, which will only work for one form. This is about a form, isn't it?
    EDIT - OK, could be for more than one form, but each would have to call a procedure in a standard module. Plus the suggestion I made would only be for continuous or datasheet forms, which I figured you are asking about.
    - "doesn't work" is no help. Post err msgs and where.
    - Use code tags for code/sql. Implement changes in copies of your database.
    (humor about talking to yourself apparently was too much for some)

Please reply to this thread with any new information or opinions.

Similar Threads

  1. control button to move through dates
    By sdel_nevo in forum Programming
    Replies: 2
    Last Post: 12-22-2016, 05:18 PM
  2. Runtime error 2110, cannot move focus to control
    By sanderson in forum Programming
    Replies: 7
    Last Post: 11-17-2015, 08:00 AM
  3. Replies: 3
    Last Post: 02-06-2015, 01:18 PM
  4. Replies: 3
    Last Post: 12-11-2014, 11:26 AM
  5. Replies: 4
    Last Post: 02-09-2013, 09:26 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
Tech Forums: Microsoft Office Forums