Solved Curser not going where I want (1 Viewer)

[Umpire]

I have a simple form I created using the form wizard that I use to enter part numbers. I added come control buttons to the form to close the form, see last record etc. I also added a Enter new part number button. When I click the button, the form clears and goes into entry mode as expected.

However, the curser stays on the button. I would like for the curser to go to the first field on the from. That way I can enter one record, click Add new Part Number and just start typing instead of having to stop and clink in the space for the Part Number.

I am sure there is some simple setting to do this but as an inexperienced user, I am not seeing it.

Thanks

 

[theDBguy]

Have you tried using GoToControl or SetFocus? It's not a setting, but a command.

 

[MajP]

Not sure what you are asking but if you right click in design view you can go to Tab Order. Then set your tab order. Also for most controls you can set the Tab Stop (yes, no). Select no if you do not want it to stop on the control.

 

[missinglinq]

Like theDBguy said...and use the command for finding if the Record is a New Record...like this:

Private Sub Form_Current()
 
 If Me.NewRecord Then
  PartNumber.SetFocus
 End If
 
End Sub

Linq 0):>

 

[Umpire]

Been Trying to post all day that theDBguy's suggestion worked great.
Finally it let me post.

 

[theDBguy]

Been Trying to post all day that theDBguy's suggestion worked great.
Finally it let me post.

Hi. Glad to hear you got it sorted out. Good luck with your project.

 

[arnelgp]

everybody knows about this except you?
don't get left behind, read the manual before operating.

 

[Umpire]

everybody knows about this except you?
don't get left behind, read the manual before operating.

Show me a manual for Acess365 and I will read it.
And how did you originally find out about it? Let me guess, someone told you about it.

 

[Isaac]

Umpire, post #7 definitely does not speak for all of us and certainly not me. We all learned somewhere, and there is nothing that everybody knows. Post any time you need help or get stuck. Best of luck with your project!

 

[arnelgp]

you can read older version and still it will work.