How to locate the cursor?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi everyone,

I have a main form with a subform in it. There are TextBoxes on the main
form and subform. When I open the form (main form), I'd like the cursor to
locate at one of the Textbox on the subform, say TextBox1. Any help is
appreciated.
 
If it's to be in TextBox1 when the form opens, you should probably just set
the tab orders (in the View menu in the form's Design View), or just set the
tab index to 0 in the property sheet for TextBox1. If you need it to go to
TextBox1 with each record change, try something like this, in the form's
Current event:

Sub Form_Current()
Me.TextBox1.SetFocus
End Sub
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads
http://www.datastrat.com
http://www.mvps.org/access
 
Hi, Jeff.
When I open the form (main form), I'd like the cursor to
locate at one of the Textbox on the subform, say TextBox1.
Click to expand...

In the main form's OnOpen( ) event, place the following code:

Private Sub Form_Open(Cancel As Integer)

On Error GoTo ErrHandler

Me!subfrmCtrl.SetFocus
Me!subfrmCtrl.Controls!TextBox1.SetFocus

Exit Sub

ErrHandler:

MsgBox "Error in Form_Open( ) in" & vbCrLf & Me.Name & _
" form." & vbCrLf & vbCrLf & _
"Error #" & Err.Number & vbCrLf & Err.Description
Err.Clear

End Sub

.. . . where subfrmCtrl is the name of the subform control, and TextBox1 is
the name of the text box where the cursor is located.

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.

(Please remove ZERO_SPAM from my reply E-mail address so that a message will
be forwarded to me.)
- - -
If my answer has helped you, please sign in and answer yes to the question
"Did this post answer your question?" at the bottom of the message, which
adds your question and the answers to the database of answers. Remember that
questions answered the quickest are often from those who have a history of
rewarding the contributors who have taken the time to answer questions
correctly.
 
Hi Arvin,

I have tried what you told me but it doesn’t work. The cursor (focus) always
goes to the first control in the main form, not the subform. Thank you.
 
Back
Top