Access losing Filter property

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

T Ray Humphrey - 31 Jan 2006 17:59 GMT

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

Reply to this Message

Kevin K. Sullivan - 31 Jan 2006 19:26 GMT

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

> Hi,
> I have an Access 2002 application that is run over the network from Windows
[quoted text clipped - 15 lines]
> Thanks in advance,
> Ray Humphrey

Reply to this Message

T Ray Humphrey - 31 Jan 2006 21:15 GMT

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

> I'm not sure about the "lost filter" situation, but most of my
> "unpredictable form behavior" experience has to do with movement of the
[quoted text clipped - 28 lines]
> > Thanks in advance,
> > Ray Humphrey

Reply to this Message