NextRecordBtn setFocus

[rrmangus]

I am having a problem with a form I created that I'm sure has a simple solution. I put a command button in my form to insert a new record or go to the next record in my DB. Unfortunately, when the blank record appears the focus stays on the "next" button and I want it to go to the first tab stop in the next record of the form.

I inserted the following code, but now I am getting a compile time error:

DoCmd.GoToRecord , , acNext
Forms!frmPtDenials!ACCT#.SetFocus

Thanks for any help you can give.

 

[Tim K.]

Why don't you use GoToControl instead?

DoCmd.GoToRecord , , acNext
DoCmd.GoToRecord "[ACCT#]"

 

[rrmangus]

GoToControl worked perfectly!

Thanks so much.