Hide a form

  • Thread starter Thread starter Bob
  • Start date Start date
B

Bob

I have a form that has 2 check boxes set up one "Can Call" and the other "Do
Not Call". Is there a way to skip past the Do Not Call forms? I don't have
both checked at the same time. Do I need to create a "Can Call" form only,
so I skip those "Do Not Call" records?
Thanks in advance
 
Bob said:
I have a form that has 2 check boxes set up one "Can Call" and the other "Do
Not Call". Is there a way to skip past the Do Not Call forms? I don't have
both checked at the same time. Do I need to create a "Can Call" form only,
so I skip those "Do Not Call" records?
Thanks in advance
Click to expand...

Maybe I'm being nitpicky, but I'd use only one checkbox for this.
Checked="calling is ok", unchecked = "do not call" (or some such).
Having two checkboxes with conflicting values doesn't make sense. What
does [Do Not Call]=True And [Can Call]=True mean? A contradiction.

Filter the form for the records you want. Either Filter by Form or do
it in the Open event of the form. (See DoCmd.OpenForm) You can set a
filter there so you can only see the records that match the filter
you've set.
 
Back
Top