Results 1 to 3 of 3
  1. #1
    cvansickle is offline Novice
    Windows Vista Access 2007
    Join Date
    Oct 2010
    Location
    Las Vegas, NV
    Posts
    21

    No navigating through records??

    Greeting to all you ACCESS EXPERTS!!

    First time Threader.... Log time Reader..

    I am a novice Access user. I know just enough to be dangerous. I have what may be simple question..

    I work in the sales world and I have a group of leads. They are currently added to a table. My form comes up to a page that allows them to ADD a new lead or search (using a combo box) for an exsisiting lead.

    My task is to make it so you can not see any record except the one you are working on. I do not want the ability to scan through records at the bottom and I dont want them to have the ability to "tab" through and get to the next record..



    Is this possible??

    Thanks in advance

  2. #2
    ajetrumpet is offline VIP
    Windows Vista Access 2007
    Join Date
    Mar 2010
    Location
    N/A
    Posts
    2,694
    on the form's property sheet, set the "record cycle" property to either 'current record' or 'current page' (I think that's right). set the "navigation buttons" and "record selectors'' properties to 'NO'.

    or apply a filter and just set the record cycling.

  3. #3
    cvansickle is offline Novice
    Windows Vista Access 2007
    Join Date
    Oct 2010
    Location
    Las Vegas, NV
    Posts
    21
    You guys are great!! Thanks Adam!!!

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

Similar Threads

  1. Replies: 7
    Last Post: 10-20-2010, 04:08 PM
  2. Replies: 3
    Last Post: 03-25-2010, 12:31 PM
  3. Help record navigating in forms
    By edo in forum Forms
    Replies: 0
    Last Post: 08-12-2008, 10:45 AM
  4. Treeview Control: Nodeclick --> Navigating to Record
    By greekandromancoins in forum Programming
    Replies: 0
    Last Post: 02-10-2006, 10:29 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