record lock

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • brino
    #1

    record lock

    hi all !

    i have a data entry form and the problem i have is that the users when
    they are entering data in grab the mouse and accidently move the
    roller on the mouse and move to a new record on the form when they
    havent finished entering the original record in.
    how can i lock the form on the one record and not move to another
    record until the click the "save" button that is on the form ???
    any help would be great !

    thanks

    brino

    Tags: None
    • Mark Reed
      #2
      Re: record lock

      Probably not the best solution but in the form's BeforeUpdate property, add
      the follwing code:

      If MsgBox("Have you finished editing this record?", vbYesNo + vbQuestion,
      "Finished?" ) = vbNo Then
      Cancel = True
      End If

      This will then ask the user if they have finished editing the record before
      comiting the save. If they click NO, the current record will remain on the
      form.

      Mark


      "brino" <bdsolutions200 2@yahoo.com.auw rote in message
      news:1175432112 .929519.307760@ y80g2000hsf.goo glegroups.com.. .
      hi all !
      >
      i have a data entry form and the problem i have is that the users when
      they are entering data in grab the mouse and accidently move the
      roller on the mouse and move to a new record on the form when they
      havent finished entering the original record in.
      how can i lock the form on the one record and not move to another
      record until the click the "save" button that is on the form ???
      any help would be great !
      >
      thanks
      >
      brino
      >

        Comment

        • paii, Ron
          #3
          Re: record lock

          Another option would be to filter the form to the current record then remove
          the filter after the save button is clicked.

          "brino" <bdsolutions200 2@yahoo.com.auw rote in message
          news:1175432112 .929519.307760@ y80g2000hsf.goo glegroups.com.. .
          hi all !
          >
          i have a data entry form and the problem i have is that the users when
          they are entering data in grab the mouse and accidently move the
          roller on the mouse and move to a new record on the form when they
          havent finished entering the original record in.
          how can i lock the form on the one record and not move to another
          record until the click the "save" button that is on the form ???
          any help would be great !
          >
          thanks
          >
          brino
          >

            Comment

            Previous template Next
            Working...