Access losing Filter property

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,
I have an Access 2002 application that is run over the network from Windows
XP. The main form has a Treeview control and a subform that shows the record
of the selected item in the tree. I am using the Filter property of the Form
to show only the selected record.

Routinely, but not predictably, a Form_Current event will fire and Access
will point the form to another record (actually, always to the first record
alphabetically). At that time, the Filter property is empty. In other words,
Access loses the Filter property setting.

I have a bit of kludge fix that resets the Filter in the Form_Current, but
if the user was editing a record, it gets saved when the event fires. I'd
rather understand the cause or create a better workaround.

Has anyone seen this behavior before? Any ideas on how to fix this?

Thanks in advance,
Ray Humphrey
 
I'm not sure about the "lost filter" situation, but most of my
"unpredictable form behavior" experience has to do with movement of the
mouse wheel. When a user moves the mouse wheel in Access, the form will
page up or down records, which would fire Form_Current for each
movement. The best method to prevent this comes from Stephan Lebans:
http://www.lebans.com/mousewheelonoff.htm

Just a stab in the dark, and again, not related to the filter.

HTmightH,

Kevin
 
It's a good thought, but the mouse wheel is not involved here. This will
happen when all you are doing is looking at the screen (and breathing, I
guess). It will even happen when you are out of the room.

But thanks for the link about the mouse wheel. I've run into that problem in
other places and will look forward to that solution.

Cheers,
Ray
 
Back
Top