Need Slight help

[merlinemet]

Using Access 2007. Have a command button to reset the form, however, when clicked, it skips half way down the page. Would like it to be set to after I click the command button, it will default to specific location on the form

 

[gemma-the-husky]

reset?

what command is on the button?

it may be going to the control designated as tab order 1. right click the form (maybe form section) select tab order, and set the controls in the tab order you require.

 

[plog]

Put a SetFocus command at the end of the reset code:

http://msdn.microsoft.com/en-us/library/aa221598(v=office.11).aspx