Move to subform field

A

Alan Z. Scharf

Question
-------------
Is there a way to move to atextbox specific control on a long subform so
that the subform's specified field is positioned at the top of the screen?

Details
-------
1. I have a routine which searches for text in a chosen subform field.

2. I put code in the Oncurrent event to go to the particular field being
searched on each time the user "thumbs through" the filtered records.

Me.sfrmReviews.SetFocus
Me.sfrmReviews.Controls(varColumnName).SetFocus

3. The problem is that the subform is long - it takes three page downs to
go
to the end.

Hence, for fields near the bottom of the subform, the focus goes to the
desired control, but the user still has to page down to see the control.

4. I tried GoToControl, but the result is the same.

5. I'm trying to avoid using PageBreaks and GoToPage because of different
user screen resolutions.

Thanks.

Alan
 
Top