DoCmd.OpenForm method - go straight to EOF ( recordset ) ?

[liamfitz]

Can I use the OpenForm method, to open my form based on a query, and go IMMEDIATELY to EOF i.e. ready to add a new record ? Here's my current statement, with just the query name to qualify it. Thanks.

DoCmd.OpenForm "frmClients", , qry1

 

[MStef]

In Form Load event put the code.

DoCmd.GoToRecord,,acNewRec

 

[liamfitz]

Muchos gracias Mstef. It works perfectly !