L
Lee
Hello all,
You guys have been so helpful in the past so I'm going to
ask yet another question of you all.
Is there anyway round this annoying (but not very
critical)problem...
I have a main form which contains a subform that's in
Continuous Forms view. The subform lists lots of records
which are flagged ready for archiving once they've been
dealt with (Yes, it's this old chestnut again!).
To do this, users click on a button and some code is
executed that sets the archive flag, requeries the record
(so you can see the flag on the subform) and then returns
the focus to the current record via a bookmark. This all
works OK BUT, supposing the subform contains 50 records -
only 15 can be displayed at any one time so you obviously
use the scrollbar to view the other 35 records. As soon
as you get past the first 15 (or so) records and flag a
record, the bookmark wants to be the first in the list
and 'jumps' to the top of the form - whereas the record
you flagged may have been in the middle of the form.
This is quite disorientating because the record that you
were looking at moves up the screen and it has lead to
the wrong records being flagged.
Is there anything I can do to stop this 'movement'
happening? I've even tried setting the subform to 'no
scrollbars' whilst the flagging is happening in the vain
hope that if there isn't a scrollbar it wont move but
alas I was wrong!
Anyway, sorry for the long explanation but any advice
would be really appreciated.
Regards,
Lee
You guys have been so helpful in the past so I'm going to
ask yet another question of you all.
Is there anyway round this annoying (but not very
critical)problem...
I have a main form which contains a subform that's in
Continuous Forms view. The subform lists lots of records
which are flagged ready for archiving once they've been
dealt with (Yes, it's this old chestnut again!).
To do this, users click on a button and some code is
executed that sets the archive flag, requeries the record
(so you can see the flag on the subform) and then returns
the focus to the current record via a bookmark. This all
works OK BUT, supposing the subform contains 50 records -
only 15 can be displayed at any one time so you obviously
use the scrollbar to view the other 35 records. As soon
as you get past the first 15 (or so) records and flag a
record, the bookmark wants to be the first in the list
and 'jumps' to the top of the form - whereas the record
you flagged may have been in the middle of the form.
This is quite disorientating because the record that you
were looking at moves up the screen and it has lead to
the wrong records being flagged.
Is there anything I can do to stop this 'movement'
happening? I've even tried setting the subform to 'no
scrollbars' whilst the flagging is happening in the vain
hope that if there isn't a scrollbar it wont move but
alas I was wrong!
Anyway, sorry for the long explanation but any advice
would be really appreciated.
Regards,
Lee