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

On Fri, 15 Aug 2008 06:50:57 -0700 (PDT), alex <sql_aid@yahoo.com>
wrote:

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

-Tom.
Microsoft Access MVP


>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

On Aug 15, 10:07*am, Tom van Stiphout <no.spam.tom7...@cox.net> wrote:
> On Fri, 15 Aug 2008 06:50:57 -0700 (PDT), alex <sql_...@yahoo.com>
> wrote:
>
> My thought is you should programmatically set the focus on the subform
> control.
>
> -Tom.
> Microsoft Access MVP
>
>
>
> >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- Hide quoted text -
>
> - 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

"alex" <sql_aid@yahoo.com> wrote in message
news:f3a7fca6-57b7-4145-9cb6-a9b15386eb76@m73g2000hsh.googlegroups.com...
On Aug 15, 10:07 am, Tom van Stiphout <no.spam.tom7...@cox.net> wrote:
> On Fri, 15 Aug 2008 06:50:57 -0700 (PDT), alex <sql_...@yahoo.com>
> wrote:
>
> My thought is you should programmatically set the focus on the subform
> control.
>
> -Tom.
> Microsoft Access MVP
>
>
>
> >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- Hide quoted text -
>
> - 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

On Aug 15, 11:06*am, "Clif McIrvin" <clare....@nevergmail.com.invalid>
wrote:
> "alex" <sql_...@yahoo.com> wrote in message
>
> news:f3a7fca6-57b7-4145-9cb6-a9b15386eb76@m73g2000hsh.googlegroups.com...
> On Aug 15, 10:07 am, Tom van Stiphout <no.spam.tom7...@cox.net> wrote:
>
>
>
>
>
> > On Fri, 15 Aug 2008 06:50:57 -0700 (PDT), alex <sql_...@yahoo.com>
> > wrote:
>
> > My thought is you should programmatically set the focus on the subform
> > control.
>
> > -Tom.
> > Microsoft Access MVP
>
> > >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- Hide quoted text -
>
> > - 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

"alex" <sql_aid@yahoo.com> wrote in message
news:5544e6b4-2ad3-4a65-9868-522668033aab@k30g2000hse.googlegroups.com...


> I got it; thanks Clif!
>
> alex

Great!

--
Clif
Still learning Access 2003