Page 2 of 2 FirstFirst 12
Results 16 to 17 of 17
  1. #16
    CJ_London is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    11,938

    is have a check box set to false if option 5 is selected and true if 1,2,3,4 are selected
    replace with your control names but you can just do this with one line of code

    checkbox=selected<>5

  2. #17
    NJTrucker is offline Novice
    Windows 10 Office 365
    Join Date
    Jul 2025
    Posts
    6
    Quote Originally Posted by June7 View Post
    Did you see posts 7 and 9? Checkbox need not be dependent on combobox.
    Until there is a value in TerminationDate, checkbox should be True.
    Really don't need "Terminated" value for Region. This is actually redundant because of TerminationDate field. Could leave with the last assigned region or Null. Code could change Region value when a TerminationDate is entered, even to set field to "Terminated". Not reliant on user to select "Terminated" in combobox.

    Thanks to everyone i got it to work, thx

    I'm kind of new to Access and don't understand some what was posted.

    But i think i would need the option 5 terminated as that is how i show the termination date field or the Hire date field

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

Similar Threads

  1. Replies: 12
    Last Post: 04-16-2020, 10:25 AM
  2. Replies: 5
    Last Post: 09-14-2018, 06:08 AM
  3. Replies: 3
    Last Post: 10-24-2012, 05:41 PM
  4. Where Can I Get Info On Modules
    By aamer in forum Access
    Replies: 1
    Last Post: 08-24-2012, 11:33 PM
  5. Replies: 3
    Last Post: 01-31-2011, 11:47 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
  •  
Other Forums: Microsoft Office Forums