Results 1 to 6 of 6
  1. #1
    DaveT99 is offline Advanced Beginner
    Windows 10 Access 2016
    Join Date
    Mar 2018
    Location
    SPAIN
    Posts
    94

    How Create a GO TO RECORD Number Field

    Is it possible to create a field on a Form to scroll through to a specific record number, e.g 50 of 400 records



    Have googled this without success

  2. #2
    kd2017 is offline Well, I tried at least.
    Windows 10 Access 2016
    Join Date
    Jul 2017
    Posts
    1,165
    Does the record selector on the bottom left corner of the form not work for you?

    Btw I can't imagine scrolling to a specific record number being terribly useful. Most people would like to scroll to a specific identifier, a simple record number is just the number in that list at that time and may not be consistent.

  3. #3
    DaveT99 is offline Advanced Beginner
    Windows 10 Access 2016
    Join Date
    Mar 2018
    Location
    SPAIN
    Posts
    94
    Thanks for the reply

    I didnt know you could do that, have used access for a number of years and never done

    Yes scrolling is required as reviewing records based on a certain critieria to do updates to many fields, and if I haventt finished when I look again want to start where I left off

    Cheers

  4. #4
    kd2017 is offline Well, I tried at least.
    Windows 10 Access 2016
    Join Date
    Jul 2017
    Posts
    1,165
    Does the record selector on the bottom left suffice? Otherwise I might suggest a feild on the records to indicate is they've been reviewed or not.

  5. #5
    Join Date
    Apr 2017
    Posts
    1,775
    When you want to scroll through some lot of records filtered by some criteria, and edit those records, I'd go for continuous form with this table as source. In form header, I'd some control(s) where filter condition(s) can be set. Filter control(s) AfterUpdate event(s) are resetting Filter property of form.

  6. #6
    DaveT99 is offline Advanced Beginner
    Windows 10 Access 2016
    Join Date
    Mar 2018
    Location
    SPAIN
    Posts
    94
    Quote Originally Posted by kd2017 View Post
    Does the record selector on the bottom left suffice? Otherwise I might suggest a feild on the records to indicate is they've been reviewed or not.
    Thanks I have used that before but didnt want use that as a partial update .............Thanks once again

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

Similar Threads

  1. Replies: 5
    Last Post: 06-02-2015, 02:51 PM
  2. Replies: 16
    Last Post: 06-20-2013, 09:25 AM
  3. Create new number for each record
    By dlab85 in forum Forms
    Replies: 6
    Last Post: 02-07-2013, 07:28 AM
  4. Replies: 37
    Last Post: 01-29-2013, 10:50 AM
  5. Replies: 2
    Last Post: 06-06-2012, 09:35 AM

Tags for this Thread

Posting Permissions

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