Not wanting to displaying certain forms

  • Thread starter The Dog Breeders List
  • 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
 
J

Jeanette Cunningham

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
 

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

Similar Threads

Can a Check Box Prevent Other Fields from Being Used? 1
Hide a form 1
Total only specific records on a continuous form 2
Data entry to table from a form 1
How to finding student Rank and How to upload bulk marks of each student at a time. 1
Open a form from a menu bar 4
Copy record info into new form 0
default value for check box 3

Top