Hello,
This is the first time I have had to resort to posting on here, as Ive
always been able to find a solution to my problems in the past by
browsing postings by others. So, to start with I thank you all for so
much help in the past ...
To my current problem... Ive a fairly sizable application, front end
local and back end networked both on access 97. All running on NT4
worstation front ends, think the back end servers are 2000, but this
is pretty transparent to me. The front end is essentially one very
large tab form with numerous interlinked subforms. Essentially the
tabs are hierarchical and up at the top level is a datasheet subform
that controls the reference for most of the other sub forms.
The problem I am experiencing is that you'll have an item selected on
the top level and the subforms aligned to this, but then if you launch
either internet explorer or adobe the top level items resets to the
first item on the list, the sub forms remain on the old reference and
so there is misalignment between the main form and the sub forms.
The requerying of the subforms is done through code whenever a change
is made to the item selected on the top level list. So whatever is
causing the list to revert to the first item in the list does not seem
to actually trigger an access event, elsewise the subforms would get
requeried as well.
Ive had countless goes at it but don't really know where to start as
the problem appears almost to be operating system related rather than
access. Any thoughts or ideas would be very much appreciated.
(Apologies in advance that this is all pretty fred flintstone
technology)
Thanks in advance
Tim