Adding a new record

[hinckleyj]

I have created a form and have placed the usual Next, Previous, Close buttons. These all work fine. I have now added a new button to create a new record and selected Record Operation > New Record to perform this. However, when I click this, a blank record is displayed but my cursor will not focus on the field.
How can you force the cursor to a particular field after clicking a button?

Thanks to all,

John H

 

[RuralGuy]

Maybe Stephan Leban's Navigation Buttons sample db will give you some fresh ideas.

 

[MarkK]

In the event handler for the clicked button, call the .SetFocus method of the control you'd like to have the focus.

Private Sub cmd1_click()
  ...your click handling code here
  Me.txtGetsFocus.SetFocus
End Sub

 

[hinckleyj]

Hi Lagbolt,
What would be my click handling code?
Also, how do I chose which field gets focus?

Thanks for your reply
John

 

[missinglinq]

"What would be my click handling code?"

That would be the code you already have in place to take you to a new record, i.e. the code the Access Wizard put behind your button.

 

[hinckleyj]

Thanks

Many thanks to all.

Problem solved!