D
doyle60
I have a subform on a main form that runs long, 100 or so records.
Users click records they want to show up in a report.
But after each click, I need to update the main form data, a response
to that click.
But if the user clicks record 88, a scroll down, the sub, because the
form is being requeried on each click, jumps to the top. Therefore
pressing line 92, 93, and 94 becomes a real hassle. After each click,
the form jumps to the top, making the next choice out of view.
I wish I could have a command button that updates the data after all
selections and not after each. But in this case, I really need to
update after each click.
How do I get the sub to stay in the same place?
Thanks,
Matt
Users click records they want to show up in a report.
But after each click, I need to update the main form data, a response
to that click.
But if the user clicks record 88, a scroll down, the sub, because the
form is being requeried on each click, jumps to the top. Therefore
pressing line 92, 93, and 94 becomes a real hassle. After each click,
the form jumps to the top, making the next choice out of view.
I wish I could have a command button that updates the data after all
selections and not after each. But in this case, I really need to
update after each click.
How do I get the sub to stay in the same place?
Thanks,
Matt