Automatically Going to top of form

[stu_c]

Hi all
I have a form with sub forms etc, across the bottom I have buttons that allows the users to scroll through the different records, one of the buttons allows users to crate a new record, it is possible that when this is clicked it takes the user back to the top of all forms?

 

[theDBguy]

Have you tried using the SetFocus method? I'm not sure what you mean by top. You can set the focus to the first Textbox.

 

[stu_c]

Have you tried using the SetFocus method? I'm not sure what you mean by top. You can set the focus to the first Textbox.

I have yes, It puts the cursor in that box but does not put the scroll bar back to the top of each from

 

[Gasman]

Well hopefully the subform would be linked to the main form, so a new record would not show anything?
Otherwise I would have thought you would need to MoveFirst for each recordset in each subform?
Or simply requery them?

 

[LarryE]

DoCmd.GoToRecord acActiveDataObject, , acFirst