access 2003 jumps to first record of form when switching to another application

[SteveF]

Hi, does anyone know what causes access (2003) to jump to the first
record of a form when you switch to another application? I have a main
form with a tab control. Each tab has various forms/subforms. This
behavior is happening with single forms, continuous forms, and
datasheet forms. It's really disconcerting when your working on a
record to have the application jump to another record everytime you
switch to another app. The database is split into front/backend.

Many Thanks

 

[boblarson]

Is there any code in the Activate event of the form?
--


Bob Larson
HTH

____________________________________
Access 2000, 2003, 2007, SQL Server 2000, Crystal Reports 10/XI, VB6
WinXP, and Vista

 

[SteveF]

I've narrowed it down to a "on load" event of a subform that applies a
filter to the subform. Is there any way to have a form filtered when
it opens without having this widespread effect on the entire
application?

 

[SteveF]

It seems like filters are not good for an app with multiple forms.
I'll have to manipulate the record source instead.

 

[Marshall Barton]

It seems like filters are not good for an app with multiple forms.
I'll have to manipulate the record source instead.

There is a known "feature" of the filter property so if you
set a filter on a subform, it clears the filter on the main
form and any other subforms. Setting the main form's filter
clears the filter on all subforms. For more details see:
http://allenbrowne.com/bug-02.html

AFAIK, this has nothing to do with other applications or
other mainforms or their subforms.