D
dchendrickson
I am using Access2002/XP Pro.
I have a subform showing data in the datasheet format.
When the focus enters a particular field in the
datasheet, a popup form opens and the data is
manipulated. When the manipulation is completed, the
popup form closes, the subform is refreshed, the record
that was just manipulated is made current, and the focus
is set to the first field so that you are right back
where you started before the code ran. All of that works
fine.
When the record count is longer than the space available
on the form and when the above routine completes, the
current record is the very bottom record displayed in the
subform window. Usually the next thing for the user to do
is work on the next record. And since that record is out
of site, the user has to scroll down by means of the
scroll bar, the scroll arrows, or the mouse wheel.
I would like to add a line of code to the above routine
that will cause the datasheet to scroll down a few lines
automatically.
I thought I could use SendKeys and the down arrow, but
that changes the current record. Is there a simple way to
send a mouse wheel or scrolldown command?
Thanks for your time.
-dc
I have a subform showing data in the datasheet format.
When the focus enters a particular field in the
datasheet, a popup form opens and the data is
manipulated. When the manipulation is completed, the
popup form closes, the subform is refreshed, the record
that was just manipulated is made current, and the focus
is set to the first field so that you are right back
where you started before the code ran. All of that works
fine.
When the record count is longer than the space available
on the form and when the above routine completes, the
current record is the very bottom record displayed in the
subform window. Usually the next thing for the user to do
is work on the next record. And since that record is out
of site, the user has to scroll down by means of the
scroll bar, the scroll arrows, or the mouse wheel.
I would like to add a line of code to the above routine
that will cause the datasheet to scroll down a few lines
automatically.
I thought I could use SendKeys and the down arrow, but
that changes the current record. Is there a simple way to
send a mouse wheel or scrolldown command?
Thanks for your time.
-dc