Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

Record or Form editing control

Discussion in 'Information Technology' started by GL, Nov 9, 2005.

  1. GL

    GL
    Expand Collapse
    Guest

    Hi

    I would like to control record editing in a multi user data base.
    Record editing in that specific application is performed only through forms.
    Do I have to set record locking, form locking, or both?
    How can I do it programmatically?

    Thanks

    GL
     
  2. Loading...


  3. [MVP] S.Clark

    [MVP] S.Clark
    Expand Collapse
    Guest

    You can open the form as readonly. Place a command button that requires
    being clicked to edit the record.

    Docmd.OpenForm "Formname", ,,,acFormReadOnly

    In the Onclick:
    me.allowedits = True

    In the after update for the form
    me.allowedits = false

    --
    Steve Clark, Access MVP
    http://www.fmsinc.com/consulting
    *FREE* Access Tips: http://www.fmsinc.com/free/tips.html


    "GL" <GL@discussions.microsoft.com> wrote in message
    news:9C97CB44-2153-48E5-9DFB-5742B8583996@microsoft.com...
    > Hi
    >
    > I would like to control record editing in a multi user data base.
    > Record editing in that specific application is performed only through
    > forms.
    > Do I have to set record locking, form locking, or both?
    > How can I do it programmatically?
    >
    > Thanks
    >
    > GL
     

Share This Page