G
Guest
What is the logic behind the ignoring of Allow Filters set to yes on a
subform if the main form has this property set to no?
I really need this and have spent days trying to get a solution the nearest
I've got is this code in the main form:
Private Sub Form_ApplyFilter(Cancel As Integer, ApplyType As Integer)
'prevent filtering of cases - causes errors.
MsgBox "You cannot sort or filter cases here."
Cancel = True
Exit Sub
End Sub
But for some reason in Access 20007 (not 2003) it runs twice - on any form.
----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.
http://www.microsoft.com/office/com...ae7a873c0875&dg=microsoft.public.access.forms
subform if the main form has this property set to no?
I really need this and have spent days trying to get a solution the nearest
I've got is this code in the main form:
Private Sub Form_ApplyFilter(Cancel As Integer, ApplyType As Integer)
'prevent filtering of cases - causes errors.
MsgBox "You cannot sort or filter cases here."
Cancel = True
Exit Sub
End Sub
But for some reason in Access 20007 (not 2003) it runs twice - on any form.
----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.
http://www.microsoft.com/office/com...ae7a873c0875&dg=microsoft.public.access.forms