SetFocus to current field

[MikeF]

To prevent accidents, my forms are set to not allow edits.

When edits are required, I click a button whose code is the following:

Me.AllowEdits = True

Would like to add "stay on current field" to that code.
So in short, whatever field I'm on in the form when the EditCurrentRecord
button is clicked, that's where the focus needs to be set.

Assistance is appreciated.
Regards,
- Mike

 

[Dirk Goldgar]

To prevent accidents, my forms are set to not allow edits.

When edits are required, I click a button whose code is the following:

Me.AllowEdits = True

Would like to add "stay on current field" to that code.
So in short, whatever field I'm on in the form when the EditCurrentRecord
button is clicked, that's where the focus needs to be set.

Well, when the EditCurrentRecord button is clicked, *that's* the current
control. <g> So what you really want is the previous control. Try this:

Me.AllowEdits = True
Screen.PreviousControl.SetFocus

 

[MikeF]

Works great, thanx Dirk.
- Mike

Well, when the EditCurrentRecord button is clicked, *that's* the current
control. <g> So what you really want is the previous control. Try this:

Me.AllowEdits = True
Screen.PreviousControl.SetFocus


--
Dirk Goldgar, MS Access MVP
www.datagnostics.com

(please reply to the newsgroup)