A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Using Forms
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Hide a form



 
 
Thread Tools Display Modes
  #1  
Old September 1st, 2006, 12:24 AM posted to microsoft.public.access.forms
Bob
external usenet poster
 
Posts: 4
Default Hide a form

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


  #2  
Old September 1st, 2006, 12:36 AM posted to microsoft.public.access.forms
[email protected]
external usenet poster
 
Posts: 264
Default Hide a form


Bob wrote:
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.

 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 02:26 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.