Unable to Remove Filter

T

tkosel

Using Access 2000, I have a form that displayed a bunch of records. I
started to fool with Filters, but couldnt get them to work right.

Private Sub Form_Open(Cancel As Integer)
me.filter = "((QueryForOrderEntryMainMenuLookup.MfgEngrRep=35))"
me.filteron = true
end sub

It didn't work, unless I chose The menu choice "apply filter sort", then it
filtered. But it got even worse. Now, I can't seem to get rid of the
filter. When my form loads, even though I have removed all the filtering
code, no records are displayed until I chose "Remove filter sort" from the
menu. What am I doing wrong? How to I permanently eliminate the filtering
from my form?
 
Top