I have a form with two linked subforms on it. The first subform is quite long.
When I open the form I want the focus of the subform to be on the first
field. Quite often it is half way along and I have to scroll all the way back
to the start before I can enter a record.
Does anyone know how to achieve this?
on the main form LOAD event, try this:
me.subform_controlname.setFocus
me.controlname.setFocus
WHERE
subform_controlname is the Name property of the subform control
controlname is the Name property of the control you wish to have the focus
Warm Regards,
Crystal
Access Basics
8-part free tutorial that covers essentials in Access
http://www.AccessMVP.com/strive4peace
*
(: have an awesome day :)
*
> I have a form with two linked subforms on it. The first subform is quite long.
>
[quoted text clipped - 3 lines]
>
> Does anyone know how to achieve this?