Results 1 to 6 of 6
  1. #1
    ortizimo is offline Advanced Beginner
    Windows XP Access 2010 32bit
    Join Date
    Jun 2017
    Location
    FL
    Posts
    88

    Jump To Record


    i have a form that shows me the [Form].[CurrentRecord] and on the other side a Count[(ID)] this way I can see the record I'm on and the total records. I've tried making a Jump To Record just like a Search just to jump to any number but cannot make it work. What would be the correct code for doing a simple textfield and a button just to enter a record number? I've tried an unbound field with a button to do the search from using Like "*" for the CurrectRecord. Thanks. PS, not using the macro which opens the default find and replace form.

  2. #2
    rpeare is offline VIP
    Windows XP Access 2003
    Join Date
    Jul 2011
    Posts
    5,442
    if you're using a bound form (which I'm assuming you're doing) can't you just type in the number of the record you want in the record selector box at the bottom of your form? I don't use bound forms but this seems the easiest without having to do any extra coding.

  3. #3
    ortizimo is offline Advanced Beginner
    Windows XP Access 2010 32bit
    Join Date
    Jun 2017
    Location
    FL
    Posts
    88
    Quote Originally Posted by rpeare View Post
    if you're using a bound form (which I'm assuming you're doing) can't you just type in the number of the record you want in the record selector box at the bottom of your form? I don't use bound forms but this seems the easiest without having to do any extra coding.
    Yes...but i'm trying to get rid of the seach selector and have one on my own...but I get what you're saying...

  4. #4
    rpeare is offline VIP
    Windows XP Access 2003
    Join Date
    Jul 2011
    Posts
    5,442
    If you don't do that I would suggest a search function rather than going to record x, particularly if you can delete data from your table. if you have record 1 through 10 today and record 1 through 12 tomorrow but record 3 and 4 have been deleted going to record 5 will result in different results each day. Also the person using the database would have to know which record number was relevant. It would probably be a better idea to supply an unbound control (or a couple of controls) to help the user search for specific items then display the subset of records rather than always looking at the entire dataset.

  5. #5
    ortizimo is offline Advanced Beginner
    Windows XP Access 2010 32bit
    Join Date
    Jun 2017
    Location
    FL
    Posts
    88
    Quote Originally Posted by rpeare View Post
    If you don't do that I would suggest a search function rather than going to record x, particularly if you can delete data from your table. if you have record 1 through 10 today and record 1 through 12 tomorrow but record 3 and 4 have been deleted going to record 5 will result in different results each day. Also the person using the database would have to know which record number was relevant. It would probably be a better idea to supply an unbound control (or a couple of controls) to help the user search for specific items then display the subset of records rather than always looking at the entire dataset.
    copy that...I already have a search function that searches all over the form for related words with and gives me a total of items found...I just wanted a quick jump-to like function for bookmarking purposes...If I find a solution I'll repost...thnx 4 ur help!

  6. #6
    orange's Avatar
    orange is online now Moderator
    Windows 10 Access 2010 32bit
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,716
    There are no record numbers per se. There are unique identifiers for records if you have normalized your table and assigned a primary key.
    Perhaps an example from your data would help.

    You may find Findfirst useful.

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

Similar Threads

  1. Jump to Record
    By control1 in forum Access
    Replies: 16
    Last Post: 04-07-2017, 10:18 AM
  2. How to Open form and jump to certain record?
    By behnam in forum Programming
    Replies: 3
    Last Post: 06-05-2014, 08:45 AM
  3. Using a Combo Box to jump to a record
    By Access_Novice in forum Forms
    Replies: 3
    Last Post: 11-19-2013, 04:14 PM
  4. Text Box - Jump to Record
    By drow in forum Forms
    Replies: 5
    Last Post: 03-12-2012, 11:25 PM
  5. How to jump on a new record when forms open?
    By braveali in forum Programming
    Replies: 3
    Last Post: 02-21-2012, 08:17 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
  •  
Other Forums: Microsoft Office Forums