View Single Post
  #2  
Old May 25th, 2010, 10:41 PM posted to microsoft.public.access.forms
Jeanette Cunningham
external usenet poster
 
Posts: 2,190
Default Not wanting to displaying certain forms

I have 2 different answers for you, depending on what I think you meant.
1. If you have a continuous form, you can lock the rows marked as do not
call.
Put code on the current event of the form like this:

If Me.DoNotCall = True Then
Me.ControlName.Enabled = False
Else
Me.ControlName.Enabled = True
End If


2. Perhaps you are asking about hiding the rows marked as do not call.
You can do this in the query used for the form's record source.
In the query, exclude the column for do not call, and under the column for
can recall, put True on the criteria line.


Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia


"The Dog Breeders List" wrote in message
...
I have a form, where I have 2 check marked boxes "Can recall" and "Do not
call". What do I need to do to skip the forms that are marked "Do not
call"?

Thanks,
Bob