Results 1 to 3 of 3
  1. #1
    KerryAustin is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Aug 2014
    Posts
    27

    Checkbox to Hide Fields not working

    I have a subform in a navigation form where I placed a bound checkbox, when selected will hide several fields I do not want the user to fill in. It was working several days ago and now it is not. I do not get an error message or anything that alerts to an issue. In the After Updatre Event I have the following code:

    'Hides Fields based on Checkbox
    Private Sub DelayInfoOnly_AfterUpdate()
    If Me.DelayInfoOnly = True Then
    Me.txtMRN.Visible = False
    Me.txtAssessionNumber.Visible = False
    Me.txtCaseNumber.Visible = False


    Else
    Me.txtMRN.Visible = True
    Me.txtAssessionNumber.Visible = True
    Me.txtCaseNumber.Visible = True
    End If
    End Sub

    I noted at the botom left corner of Access Screen when I click on the checkbox, it shows the label and then states it is calculating. Appears to be doing something but does not hide the fields. I was just in the process of spliting the database, had made a copy/backup. at first the split was working as well. Now the backup and split is not. Any idea why this wouldn't work?
    Here is a copy of the Form.
    Attached Thumbnails Attached Thumbnails NavPage2.jpg  

  2. #2
    KerryAustin is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Aug 2014
    Posts
    27
    I found the issues, I had macros disabled under Trust Center Settings.

  3. #3
    ItsMe's Avatar
    ItsMe is offline Sometimes Helpful
    Windows 7 64bit Access 2010 32bit
    Join Date
    Aug 2013
    Posts
    7,862
    Quote Originally Posted by KerryAustin View Post
    I found the issues, I had macros disabled under Trust Center Settings.
    This is interesting information. Thank you for sharing your solution.

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

Similar Threads

  1. Checkbox not working right
    By NISMOJim in forum Programming
    Replies: 4
    Last Post: 04-05-2014, 10:10 AM
  2. Replies: 3
    Last Post: 01-14-2014, 04:17 PM
  3. hide checkbox in a form
    By hung_ko in forum Forms
    Replies: 11
    Last Post: 01-26-2011, 11:50 AM
  4. Checkbox not working
    By terryvanduzee in forum Programming
    Replies: 4
    Last Post: 10-23-2009, 10:36 AM
  5. Replies: 0
    Last Post: 01-06-2009, 03:27 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