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

  • Thread starter Thread starter SteveF
  • Start date Start date
S

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
 
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
 
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?
 
It seems like filters are not good for an app with multiple forms.
I'll have to manipulate the record source instead.
 
SteveF said:
It seems like filters are not good for an app with multiple forms.
I'll have to manipulate the record source instead.
Click to expand...


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.
 
Back
Top