Setting Focus to a Subform

[Scott Viney]

Afternoon All,

I have a simple form with a subform in datasheet view.
Its a real pain scrolling down in the subform everytime I want to add new
data.

How can I when the main form is first opened set the focus to a new record
in the subform? Then also when I change the record of the main form do the
same thing in the newly displayed subform?

Cheers,
Scott V

 

[Guest]

On the On current event of the main form you can write the code

Me.SubFormName.SetFocus
DoCmd.GoToRecord , , acNewRec

Good luck

 

[Scott Viney]

Cheers Mate,

Works like a charm.

Scott V

On the On current event of the main form you can write the code

Me.SubFormName.SetFocus
DoCmd.GoToRecord , , acNewRec

Good luck