Results 1 to 2 of 2
  1. #1
    Bill_Access_Learner is offline Novice
    Windows 10 Access 2013 64bit
    Join Date
    Mar 2016
    Posts
    1

    How to have a checkbox = true based on information in a table or query?

    Hi, new to the forums, but have been browsing here for awhile. Would consider my self a beginner Access user.


    I have a question I was hoping I could get some assistance with(access 2013).




    I'm working on a database that stores information concerning mandatory training employees must complete.


    Separate tables exist for Students, Instructors, Training Topics, and Training Completion information


    Some, but not all, of the mandatory training requires the generation of a training certificate upon completion.


    Let's say that I have 10 Training Topics that require a certificate when complete.


    What I would like to do is have a form with 10 checkboxes, each one of which would be true, or "checked" if a training subject were complete.


    For example, if a student completed 8 out of the 10 trainings, 8 checkboxes would become "checked", I could then print a certificate containing the information related to the 8 checkboxes, and the students would get a second certificate once they completed the remaining tasks.



    So lets say the student/completed a training called "Orientation", it was recorded in a table, how could I get a checkbox to reflect "true" for this condition?


    Thanks in advance.

  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,550
    If the field is set to yes/no, then when you place a checkbox on the form,linked to the field,
    it will show a check mark when true.

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

Similar Threads

  1. On Click event filter By checkbox = True
    By nick404 in forum Programming
    Replies: 14
    Last Post: 06-05-2015, 03:08 PM
  2. Replies: 7
    Last Post: 05-30-2013, 04:22 PM
  3. Replies: 3
    Last Post: 03-08-2013, 11:34 AM
  4. if checkbox= true subtract 8.75 from A to=B
    By VanillaAwesome in forum Queries
    Replies: 6
    Last Post: 07-28-2012, 12:48 PM
  5. Replies: 4
    Last Post: 09-03-2009, 02:01 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