Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2009

    Unanswered: Check box needs required field in order to be checked?

    Hello, I'm having another issue.

    I have a check box, that, when checked, removes it from the query criteria in a form. Before this box can be checked, another field eneds to be filled in, and if it is blank I want it to return an error message.

    I have tried validation rules / text, but for what I did (Not Is Null) it wouldn't let me save the record until the field was filled in. I also tried an if statement in VBA but nothing worked there for me.

    Does anyone have any suggestions?

  2. #2
    Join Date
    May 2005
    Nevada, USA
    Provided Answers: 6
    Personally I'd use the before update event of the form:

    Before update

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts