replace with your control names but you can just do this with one line of codeis have a check box set to false if option 5 is selected and true if 1,2,3,4 are selected
checkbox=selected<>5
replace with your control names but you can just do this with one line of codeis have a check box set to false if option 5 is selected and true if 1,2,3,4 are selected
checkbox=selected<>5
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