![]() |
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. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
![]()
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 |
#2
|
|||
|
|||
![]()
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 |
#3
|
|||
|
|||
![]()
Why not just filter on the field selected.
-- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...forms/201005/1 |
Thread Tools | |
Display Modes | |
|
|