L
Louverril
I only want to allow record filtering in the subform at teh lowest level the
only way I can find to do this (allowfilters etc.. all tried) is the
following code in the maniform adn the mainfroms ist level subform.
However the code runs twice before the Applyfiler event finshed and you have
to OK the msgbox twice.
Private Sub Form_ApplyFilter(Cancel As Integer, ApplyType As Integer)
MsgBox "You can not filter these records."
Cancel = True
End sub
How can I stop this?
only way I can find to do this (allowfilters etc.. all tried) is the
following code in the maniform adn the mainfroms ist level subform.
However the code runs twice before the Applyfiler event finshed and you have
to OK the msgbox twice.
Private Sub Form_ApplyFilter(Cancel As Integer, ApplyType As Integer)
MsgBox "You can not filter these records."
Cancel = True
End sub
How can I stop this?