Results 1 to 5 of 5
  1. #1
    zwave is offline Novice
    Windows XP Access 2003
    Join Date
    Jan 2011
    Posts
    2

    Question How do I lock any field in a form after data entry

    I would like to lock a field after data has been entered to prevent users from changing the data. I would also like to include a message box that asks users whether the information entered is correct. How do I go about this?

    PS: New to Access, first real DB attempt, detailed information will be appreciated

  2. #2
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 7 64bit Access 2010 32bit
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    You do not trust your users?

  3. #3
    ajetrumpet is offline VIP
    Windows Vista Access 2007
    Join Date
    Mar 2010
    Location
    N/A
    Posts
    2,694
    Quote Originally Posted by RuralGuy View Post
    You do not trust your users?
    I enjoyed a good laugh today. Thanks Allan!

  4. #4
    zwave is offline Novice
    Windows XP Access 2003
    Join Date
    Jan 2011
    Posts
    2
    It's a medical research database, and this will only apply to certain fields such as Date of birth, Medical record #, processID etc assigned to each study participant.

  5. #5
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 7 64bit Access 2010 32bit
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    You can use the Current Event of your form to "lock" any control you choose that already contains a value.

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

Similar Threads

  1. Limit data entry based on another field
    By chemengr in forum Forms
    Replies: 5
    Last Post: 01-02-2014, 01:21 PM
  2. Replies: 9
    Last Post: 09-13-2012, 05:18 PM
  3. Data entry form
    By adept in forum Forms
    Replies: 1
    Last Post: 08-20-2010, 10:13 PM
  4. Sub Form Data Entry
    By OldBloke in forum Forms
    Replies: 1
    Last Post: 08-09-2010, 06:58 AM
  5. Can't get new field to show in my data entry form
    By Suzie in forum Database Design
    Replies: 19
    Last Post: 12-21-2009, 03:48 PM

Tags for this Thread

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