Results 1 to 2 of 2
  1. #1
    acehowell is offline Novice
    Windows XP Access 2010 32bit
    Join Date
    Apr 2007

    Make entries uneditable based on checkbox

    I have a secured form and i am looking to put a checkbox, or combo box for completed once checked or yes is selected then entries for that record are locked. I want to be able to enter information, leave checkbox unchecked and be able to go back and edit information. Once i hit add new button the fields for the next entry should be editable. Hope i have explained myself enough. Thanks.

  2. #2
    Join Date
    Apr 2007
    Portsmouth, VA
    In the form's On Current event, place a line of code similar to the following for every field you want to be enabled/disabled based on the checkbox:

    Me.FieldToTurnOff.enabled = not Me.CheckBox.Value

    You'll also want to put a line to call the On_Current event when the check is changed, otherwise, the enabled/disabled status will only be updated when you move from record to record. In the checkbox's On Change event, put something like:

    call Form_Current

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

Similar Threads

  1. Checkbox controlling text box
    By chuckduarte in forum Forms
    Replies: 0
    Last Post: 10-21-2008, 10:45 AM
  2. checkbox
    By Suresh in forum Forms
    Replies: 0
    Last Post: 12-19-2007, 01:30 AM
  3. easy checkbox question
    By nelsok in forum Forms
    Replies: 1
    Last Post: 06-09-2006, 05:46 PM
  4. Checkbox to update value
    By Wrangler in forum Forms
    Replies: 1
    Last Post: 01-03-2006, 06:34 PM
  5. access checkbox
    By nshack31 in forum Forms
    Replies: 1
    Last Post: 12-09-2005, 10:17 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