Record Selectors problem

  • Thread starter Thread starter Neil
  • Start date Start date
N

Neil

Hello,

Apologies if this is a simple question.

I have a Continuous Form with record selectors enabled. Is there a way to
loop through all the records that are selected in code and then do something
with the selected records (like you can with a list box and it's selected
property)?

Thanks,

Neil.
 
Neil said:
I have a Continuous Form with record selectors enabled. Is there a way to
loop through all the records that are selected in code and then do something
with the selected records (like you can with a list box and it's selected
property)?
Click to expand...


Not a simple question at all.

Since you can only select consecuitive records using the
record selectors and if your form were in datasheet view,
you would be able to use the SelTop and SelHeight properties
to do that kind of thing.

The only way I've bee able to that in a continuous form
and/or fornonconsecutive records is by adding a bound,
Yes/No field to the form's record source table. When the
form opens it can run an Update query to set the field to
False in all records. Then you can use a checkbox control
on the form instead of the record selectors.
 
Marshall Barton said:
Not a simple question at all.

Since you can only select consecuitive records using the
record selectors and if your form were in datasheet view,
you would be able to use the SelTop and SelHeight properties
to do that kind of thing.
Click to expand...

SelTop and SelHeight work fine in normal continuous forms view, no? The main
problem that I have found with this is, that you can not click a button to
process the selected records. Clicking the button removes the focus from the
selected records - Catch 22!

TC
 
TC said:
SelTop and SelHeight work fine in normal continuous forms view, no? The main
problem that I have found with this is, that you can not click a button to
process the selected records. Clicking the button removes the focus from the
selected records - Catch 22!
Click to expand...

Not necessarily, TC. Neil never did say how he was going to
invoke whatever it is he's trying to do. It just might(?)
be that he was thinking of using a different form or a
custom tool bar button or menu item. I doubt it, but, not
being a mind reader, who knows ;-)
 
Marshall Barton said:
Not necessarily, TC. Neil never did say how he was going to
invoke whatever it is he's trying to do. It just might(?)
be that he was thinking of using a different form or a
custom tool bar button or menu item. I doubt it, but, not
being a mind reader, who knows ;-)
Click to expand...

ok, so not a simple question....

Thanks guys, I think i'll stick to the check box way. And yes I was going to
use a command button but a menu button wouldn't have been a problem either.
:-)

Neil.
 
Back
Top