Hide a form

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
 
P

pietlinden

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

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top