Hide / Show Checkbox - Access Form

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • mcupito
    Contributor
    • Aug 2013
    • 294

    Hide / Show Checkbox - Access Form

    I've two drop down boxes. Only if both of them are ' > "" ' should the check box appear (and therefore be able to be clicked).. How is this performed?

    I am trying to prevent an error from checking a Do Not Use box when nothing is selected. Does anyone else have a better suggestion?

    Maybe put constraints on the GotFocus or something?

    Thanks

    Didn't realize I was in the Java forum. Can an admin move this? Sorry.
  • Rabbit
    Recognized Expert MVP
    • Jan 2007
    • 12517

    #2
    Your thread has been moved to the Access forum. Please show us the code that causes the error along with the full error message.

    Comment

    • mcupito
      Contributor
      • Aug 2013
      • 294

      #3
      Thanks, Rabbit.

      Here are 2 screen shots. One is of the design view, the other is form view with the error.

      I need to make sure there's a selection in Company and Line of Business before they can click the Do Not Use.
      Attached Files

      Comment

      • Rabbit
        Recognized Expert MVP
        • Jan 2007
        • 12517

        #4
        Please show us the code that causes the error.

        Comment

        • mcupito
          Contributor
          • Aug 2013
          • 294

          #5
          I simply used the If IsNull (Me.[Object].Value) Then

          Sorry if I confused you with the error aspect of my question. That was not it.

          Comment

          • Rabbit
            Recognized Expert MVP
            • Jan 2007
            • 12517

            #6
            What's the rest of the code? If there's no error, I don't understand what your question is.

            Comment

            • mcupito
              Contributor
              • Aug 2013
              • 294

              #7
              I'm not sure if I can be more clear. I explained that I wanted to check the values of 2 combo boxes to see if there was a value in either of them, and if there wasn't - it was supposed to throw an error if the checkbox is selected, which wouldn't allow it to be selected.

              Comment

              Working...