Datasheet scroll

[alex]

Hello all,

Using Access ’03…

I have a Form that contains a Subform in datasheet view. When the
Form loads, users can see the Subform (which contains two columns; one
text and one hyperlink).

I want users to be able to scroll through the datasheet with their
mousewheel when the Form loads. Currently, a user needs to “activate”
the Subform by clicking on the vertical scrollbar…then the mousewheel
works.

The reason I want the user to automatically scroll is because of the
hyperlinks. If the Subform needs to be activated manually (clicked),
I run the risk of the user inadvertently activating a hyperlink.

Thoughts?

alex

 

[Tom van Stiphout]

On Fri, 15 Aug 2008 06:50:57 -0700 (PDT), alex <[email protected]>
wrote:

My thought is you should programmatically set the focus on the subform
control.

-Tom.
Microsoft Access MVP

 

[alex]

My thought is you should programmatically set the focus on the subform
control.

-Tom.
Microsoft Access MVP








- Show quoted text -

Thanks Tom...I tried doing that but the code didn't seem to recognize
the subform. Do you have any code in mind?

alex

 

[Clif McIrvin]

My thought is you should programmatically set the focus on the subform
control.

-Tom.
Microsoft Access MVP








- Show quoted text -

Thanks Tom...I tried doing that but the code didn't seem to recognize
the subform. Do you have any code in mind?

alex


I think you need to set focus to the subform control, then set focus to
one of the subform controls:

me.[subformcontrolname].setfocus
me.[subformcontrolname].form.[controlname].setfocus

 

[alex]

My thought is you should programmatically set the focus on the subform
control.

-Tom.
Microsoft Access MVP

- Show quoted text -

Thanks Tom...I tried doing that but the code didn't seem to recognize
the subform.  Do you have any code in mind?

alex

I think you need to set focus to the subform control, then set focus to
one of the subform controls:

me.[subformcontrolname].setfocus
me.[subformcontrolname].form.[controlname].setfocus

--
Clif
Still learning Access 2003- Hide quoted text -

- Show quoted text -

I got it; thanks Clif!

alex

 

[Clif McIrvin]

I got it; thanks Clif!

alex

Great!