T
T Ray Humphrey
I have an Access XP form that occasionally moves from one record to another
with no interaction from the user. The form contains a treeview control
(which is working just fine) and a subform. The subform contains other
controls and another subform, etc.
The treeview control is how the user selects a record to view. When a tree
node is selected, I set the filter on the subform so that only one record is
available. That code works as designed. Later, when the user is either
editing a text field or often doing nothing at all, Access seems to flash,
then select a specific record in the subform. It always selects the same
record, the alphabetically-first record. As far as I can tell, the form
Filter property is not being changed, as none of my code that changes it is
running.
The treeview does not update in this and its NodeClick event does not occur.
I don't believe the Form_Current event is running for the subform either, as
I have some reporting code in there that is not running.
The database is stored on a file server and is accessed over the network.
Multiple machines in my clients' environment have exhibited this behavior,
but when I hook my laptop to the network and open the database, it does not
occur for me. All machines are running Windows XP and Office XP.
I have written many Access applications, all for access over the network,
and this is the first time I have seen this behavior. It has me quite
befuddled. Any suggestions or ideas would be appeciated.
Thanks in advance,
with no interaction from the user. The form contains a treeview control
(which is working just fine) and a subform. The subform contains other
controls and another subform, etc.
The treeview control is how the user selects a record to view. When a tree
node is selected, I set the filter on the subform so that only one record is
available. That code works as designed. Later, when the user is either
editing a text field or often doing nothing at all, Access seems to flash,
then select a specific record in the subform. It always selects the same
record, the alphabetically-first record. As far as I can tell, the form
Filter property is not being changed, as none of my code that changes it is
running.
The treeview does not update in this and its NodeClick event does not occur.
I don't believe the Form_Current event is running for the subform either, as
I have some reporting code in there that is not running.
The database is stored on a file server and is accessed over the network.
Multiple machines in my clients' environment have exhibited this behavior,
but when I hook my laptop to the network and open the database, it does not
occur for me. All machines are running Windows XP and Office XP.
I have written many Access applications, all for access over the network,
and this is the first time I have seen this behavior. It has me quite
befuddled. Any suggestions or ideas would be appeciated.
Thanks in advance,