Results 1 to 4 of 4
  1. #1
    swavemeisterg is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    May 2012
    Posts
    28

    Checkboxes not displaying properly in form

    Here's the issue:


    I created a list of entries for the user to enter, and I have a checkbox next to each of them. I created a button to select all the checkboxes, and I created a button to deselect all of them. Both buttons work fine, the problem is: even the deselected boxes, though they are technically false, still appear checked.

    They still work as if they were unchecked, but they have checks in them.

    Obviously this is not very helpful for the user.

    Any ideas?

    Here's the code for the buttons (Be gentle I'm a brand new Access user):

    Code:
    Private Sub Command1056_Click()
    
    InputByCheck = True
    MaterialCheck = True
    RecordingDateCheck = True
    ActionCheck = True
    ActionPOCheck = True
    MaterialCertCheck = True
    HeatTreatCertCheck = True
    SurfEnhCertCheck = True
    ProjectCheck = True
    CommentsCheck = True
    VendorCheck = True
    BallDiaCheck = True
    AvgHardHRCACheck = True
    AvgHardHRCBCheck = True
    MatRemACheck = True
    MatRemBCheck = True
    AvgHardHRCCheck = True
    AvgRoughACheck = True
    AvgRoughBCheck = True
    End Sub
     
    Private Sub Command1059_Click()
    InputByCheck = False
    MaterialCheck = False
    RecordingDateCheck = False
    ActionCheck = False
    ActionPOCheck = False
    MaterialCertCheck = False
    HeatTreatCertCheck = False
    SurfEnhCertCheck = False
    ProjectCheck = False
    CommentsCheck = False
    VendorCheck = False
    BallDiaCheck = False
    AvgHardHRCACheck = False
    AvgHardHRCBCheck = False
    MatRemACheck = False
    MatRemBCheck = False
    AvgHardHRCCheck = False
    AvgRoughACheck = False
    AvgRoughBCheck = False
    End Sub

  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
    Have you tried a Me.Refresh to get the Form to refresh?

  3. #3
    swavemeisterg is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    May 2012
    Posts
    28
    That did it. thanks!
    I figured there was a refresh command i just didnt know what it was

  4. #4
    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
    Great! Glad we could help.

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

Similar Threads

  1. Replies: 4
    Last Post: 07-12-2011, 09:49 AM
  2. Form queries. Multiple checkboxes.
    By radink in forum Queries
    Replies: 4
    Last Post: 04-27-2011, 07:34 AM
  3. Replies: 1
    Last Post: 11-07-2010, 11:04 AM
  4. Disable Checkboxes for a row in Form
    By seshan in forum Programming
    Replies: 1
    Last Post: 02-05-2010, 07:36 PM
  5. Replies: 2
    Last Post: 11-17-2006, 01:07 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