Results 1 to 4 of 4
  1. #1
    3 Star Lounger
    Join Date
    Sep 2001
    Location
    Stuck at work..., Missouri, USA
    Posts
    248
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Prevent users from moving between records on bound

    Is it possible to prevent users from navigating between records on a bound form?

    I can remove the navigation buttons, but using the scroll wheel or shift+tab will allow the user to go back through the records.

    I don't want that.

    Please help!

    Thanks!
    <font face="Comic Sans MS">Morgan Erickson</font face=comic>
    morgan.erickson@sprint.com
    <img src=/S/flags/USA.gif border=0 alt=USA width=30 height=18>-From <img src=/S/flags/Colorado.gif border=0 alt=Colorado width=30 height=18> but living in <img src=/S/flags/Missouri.gif border=0 alt=Missouri width=30 height=18>...and working in Kansas.

  2. #2
    3 Star Lounger
    Join Date
    Jun 2001
    Location
    Salem, Oregon, USA
    Posts
    219
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Prevent users from moving between records on bound

    How do you get to the form? Is it a "new" record that you don't wnat them to move back off of?

    It seems to me the easiest answer to your problem would be to:
    1.) if new, open the form in data entry mode only (although w/o further provisions, they would be able to scroll amongst the records they already added), or
    2.) if editing a record, have the user chose the record from a selection list, then open the form filtered strictly for that one record.
    If either of these selections are what you're looking for, check the parameters that can be sent when calling a form using code or macro.
    thx
    Pat Williams

  3. #3
    3 Star Lounger
    Join Date
    Sep 2001
    Location
    Stuck at work..., Missouri, USA
    Posts
    248
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Prevent users from moving between records on b

    Yes, this is a new record that I do not want them to back off of.
    <font face="Comic Sans MS">Morgan Erickson</font face=comic>
    morgan.erickson@sprint.com
    <img src=/S/flags/USA.gif border=0 alt=USA width=30 height=18>-From <img src=/S/flags/Colorado.gif border=0 alt=Colorado width=30 height=18> but living in <img src=/S/flags/Missouri.gif border=0 alt=Missouri width=30 height=18>...and working in Kansas.

  4. #4
    4 Star Lounger
    Join Date
    Sep 2004
    Location
    Sacramento, California, USA
    Posts
    432
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Prevent users from moving between records on b

    You could go to the forms properties and make the Data Entry property yes. This should make the form open to the first new record and not allow the user to see already entered records. I am thinking there might be some issues with a scrolling mouse you might want to look into if your users have this type of mouse.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •