Not wanting to displaying certain forms

  • Thread starter Thread starter The Dog Breeders List
  • Start date Start date
T

The Dog Breeders List

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
 
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
 
Back
Top