Page 2 of 2 FirstFirst 12
Results 16 to 17 of 17

Using the expression builder to determine whether a check box is ticked or not

  1. #16
    ridders52's Avatar
    ridders52 is online now Long time standing
    Windows 10 Access 2010 32bit
    Join Date
    Jan 2014
    Location
    Somerset, UK
    Posts
    538

    As this is from the main form & only one control is on the subform then it should be

    Code:
    Private Sub Form_Current()
    
        Me.[Cog signatory the same?]=Me.[2017-18 data subform1].[Form]![Full name of person who agrees to the terms of the Conditions_01]=Me.[name on form]
    
    
    End Sub
    Or

    Code:
    Private Sub Form_Current()
    
         If Me.[2017-18 data subform1].[Form]![Full name of person who agrees to the terms of the Conditions_01]=Me.[name on form] Then Me.[Cog signatory the same?]=True
    
    End Sub
    Or follow June's suggestions

    BUT PLEASE RENAME YOUR FIELDS, FORMS, CONTROLS & LABELS .....
    Colin (Mendip Data Systems), Website, email

    If this has helped, please click the star button and leave a comment

  2. #17
    Fostertrident is offline Novice
    Windows 10 Access 2016
    Join Date
    Jan 2018
    Posts
    15
    Thank you June that works a charm. Many thanks.

    I'm sorry about the lack of renaming, it's because a lot of my data is coming from a linked table which in turn comes from an online form.

    There's a lot of columns in there so haven't look at how to do this yet.


    Thanks for your help and sorry for being ignorant about a lot of things. Made good progress today.

Page 2 of 2 FirstFirst 12
Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 4
    Last Post: 05-03-2016, 12:51 PM
  2. expression builder
    By frustratedwithaccess in forum Access
    Replies: 7
    Last Post: 11-12-2014, 08:15 AM
  3. Replies: 1
    Last Post: 04-24-2013, 02:47 PM
  4. Replies: 2
    Last Post: 11-20-2012, 02:21 AM
  5. Expression builder
    By PJ_d_DJ in forum Access
    Replies: 2
    Last Post: 02-24-2011, 02:38 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Tech Forums: Microsoft Office Forums