Sub not working !

[andrep]

stDocName = "Ventes (Dernier)"
DoCmd.OpenQuery stDocName, acNormal, acEdit
lin3 DoCmd.GoToRecord , , acNewRec

I have a sub witch runs a query, once the query has run!
I want the form to goto a new record!

The line 3 is not working, is this because the form has
lost the focus to the query ???

The sub is called from a command button !

I can't figure why line 3 is not functionning !

Any ideas !

 

[jfischer]

You are correct about the focus. The query has the focus. You can use the statements:

Me.SetFocus
Me![Field Name for Cursor].SetFocus

between running the query and positioning to a new record to get the focus back on your form. You'll also need to position your form and query windows so that they're both visible, etc.