Results 1 to 3 of 3
  1. #1
    allenom is offline Novice
    Windows XP Access 2000
    Join Date
    Sep 2011
    Posts
    4

    Force form to skip records

    Hi-


    I have a form which displays the values of a table Vehicles. It has a control at the bottom of the form that allows you to toggle through the records, or enter a specific number of a record for it to jump to. It starts at 1.
    I want it to skip the first 3 records in the table, and start at number 4. Is there a simple way to do that?
    Thanks,
    Al

  2. #2
    June7's Avatar
    June7 is online now VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    53,626
    Guess you could have code in the form's Open or Load event to immediately GoTo 4th record.

    http://msdn.microsoft.com/en-us/libr...ffice.11).aspx
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  3. #3
    allenom is offline Novice
    Windows XP Access 2000
    Join Date
    Sep 2011
    Posts
    4

    Thanks!

    Worked perfectly, thanks!

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

Similar Threads

  1. Skip a line
    By Bear in forum Queries
    Replies: 13
    Last Post: 08-19-2011, 03:17 PM
  2. Replies: 6
    Last Post: 04-13-2011, 03:55 PM
  3. Replies: 3
    Last Post: 05-24-2010, 06:56 AM
  4. Force form not to save updated fields
    By Evgeny in forum Programming
    Replies: 2
    Last Post: 04-30-2010, 10:44 PM
  5. line skip in bookmarks
    By emilylu3 in forum Programming
    Replies: 0
    Last Post: 03-21-2006, 02:58 PM

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