Results 1 to 2 of 2
  1. #1
    alex_raju is offline Advanced Beginner
    Windows XP Access 2003
    Join Date
    Jun 2011
    Posts
    56

    Question lock form or text in form after click save button...

    hi,

    how i can lock current form or a text in form after click save button?

    thanks in advance

    alex

  2. #2
    Rod is offline Expert
    Windows Vista Access 2007
    Join Date
    Jun 2011
    Location
    Metro Manila, Philippines
    Posts
    679
    Form? Not too sure apart from setting the Allow Edits, etc. properties.

    Specific control (e.g. text box)? Code something like in the form's after update event

    Me.txtYourName.Enabled = False

    and/or

    Me.txtYourName.Locked = True

    You cannot disable a control that has the focus so you may need to have a line of code immediately before the disablement

    Me.txtAnotherControl.SetFocus
    Last edited by Rod; 07-18-2011 at 07:58 PM.

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

Similar Threads

  1. Access Form- Save/Close Button error
    By Ashe in forum Forms
    Replies: 3
    Last Post: 02-10-2011, 01:01 PM
  2. On Click Event For Button On Form
    By Desstro in forum Forms
    Replies: 3
    Last Post: 08-09-2010, 02:36 PM
  3. Replies: 1
    Last Post: 03-03-2010, 07:29 PM
  4. Replies: 5
    Last Post: 02-10-2010, 12:27 AM
  5. VB coding for saving when click on save button in form
    By cwwaicw311 in forum Programming
    Replies: 1
    Last Post: 02-04-2010, 11:11 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