B
BruceS
Hi, all!
Have several forms that I open using DoCmd.OpenForm and provide a filter to
limit the records viewed. Problem is, when the form is closed and then
re-opened, that filter remains and all records are not seen. I followed the
advice in a previous post and placed
Me.Filter = ""
Me.OrderBy = ""
DoCmd.RunCommand acCmdSave
into Form_Unload. Even added Me.FilterOn = False and Me.OrderByOn = False.
Didn't help. Tried the same commands in Form_Close. Didn't work either.
Tried putting the commands just before calling Me.Close. No luck. Have also
tried making AllowFilters both True and False.
Running Access 2000. Is there way to get this to work, or is it just an
"unpublished feature" of Access?
Thanks,
Bruce
Have several forms that I open using DoCmd.OpenForm and provide a filter to
limit the records viewed. Problem is, when the form is closed and then
re-opened, that filter remains and all records are not seen. I followed the
advice in a previous post and placed
Me.Filter = ""
Me.OrderBy = ""
DoCmd.RunCommand acCmdSave
into Form_Unload. Even added Me.FilterOn = False and Me.OrderByOn = False.
Didn't help. Tried the same commands in Form_Close. Didn't work either.
Tried putting the commands just before calling Me.Close. No luck. Have also
tried making AllowFilters both True and False.
Running Access 2000. Is there way to get this to work, or is it just an
"unpublished feature" of Access?
Thanks,
Bruce