Results 1 to 4 of 4
  1. #1
    Ekhart is offline Advanced Beginner
    Windows 10 Access 2016
    Join Date
    Jun 2016
    Posts
    80

    Checkbox effect entry of Combo Box

    I have a checkbox on my form that indicates the record if completed/closed. Is there a way to have this checkbox automatically change the combobox 'Last Action' automatically set to 'Closed'? This is mainly for visual purposes so not absolutely required if it is not a simply fix

  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    In the form's ONCURRENT event:

    If ChkBox.value then cboBox= "Closed"

  3. #3
    Ekhart is offline Advanced Beginner
    Windows 10 Access 2016
    Join Date
    Jun 2016
    Posts
    80
    I tried this but it is not working, might help if I give name of the items. The checkbox is 'DCCheck' and the Combo Box is 'LastAction'. When I put the above code in I get an error, and when I have tried to put in the proper names I can think of same thing.

  4. #4
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    Replace my names with your control names.

    if the combo box has only 1 column then it should work. (String)

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

Similar Threads

  1. Checkbox based on Combo Box
    By roarcrm in forum Forms
    Replies: 2
    Last Post: 04-07-2015, 10:23 AM
  2. Shape Effect on Toggle Buttons
    By dimoc in forum Access
    Replies: 5
    Last Post: 04-10-2014, 09:28 AM
  3. Calculations Per Row Effect
    By gatsby in forum Access
    Replies: 29
    Last Post: 05-26-2013, 07:33 PM
  4. Replies: 3
    Last Post: 08-06-2012, 04:59 PM
  5. Linking checkbox to combo box
    By greatether in forum Forms
    Replies: 2
    Last Post: 12-19-2011, 12:14 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