Move cursor to a specified field

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

Guest

Does anyone have any sample code on how I can move the cursor to a specified
field on an Access form when a certain criteria is met on a subform?

Thanks in advance.
 
Hi, Marv.

To move the location of the cursor from a subform to another form that is
currently open (even if it's not the form that contains the subform in
question), try:

If (certain_criteria) Then
Forms("frmMain").txtMyField.SetFocus
End If

.... where "frmMain" is the form that has "txtMyField," the specific text box
where you want the user to type the next entry.

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.)

- - -
When you see correct answers to your question, please sign in to Microsoft's
Online Community and mark these posts, so that all may benefit by filtering
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Oversensitive touchpad on modern laptops 0
Preventing form move 1
Excel VBA to move cursor from 1 cell to another, once original cell is filled with data. 3
How to change cursor. 10
Newbie question: Specifying the field 3
Parameter query problem 1
Cursor disappears in presenter mode 0
Windows 7 automatic clicks 1

Back
Top