Placing focus in desired control of subform

[Guest]

I have a SubForm with several textboxes. (txt1, txt2, ...). the Main Form
has buttons cmdNext (DoCmd.GoToRecord , , acNext) and cmdPrev. When I click
Next, say, the next record shows as expected and the subform updates as it
should. But I'd like the cursor to go back to the same textbox it was in on
the previous record. If I'm in txt19 then click cmdNext, I want the cursor
to return to txt19. Is this easy to do?

thanks

 

[Arvin Meyer [MVP]]

You can create a form level static variable and store the name of the
control in that variable. In the Current event of the form access the
variable and SetFocus to that control.

 

[Guest]

Arvin - thanks for your prompt reply

I'm a bit new at this, but trying my best to learn. Could you spell this
out just a little more for this newbie? Lets say I'm in txt23 of subform
sfrmCity then click cmdNext on frmMain. Exactly where would I declare the
static variable and what is the syntax? Then, what code might go in
sfrmCity's Current event?

muchly appreciated

 

[Arvin Meyer [MVP]]

This is even easier. If you are in the main form's code module:

Private Sub Form_Current()
Me.NameOfSubformControl.Form.NameOfControl.SetFocus
End Sub

When moving between records in the subform, the code would read:

Private Sub Form_Current()
Me.NameOfControl.SetFocus
End Sub
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com