Focus for new record

[moose]

i have attached a .mdb because i have a feeling i am not going to explain my problem very well.
When the form opens, i want a new record to be the focus and not the 1st record in the table.
Any ideas please?

 

[MStef]

Hello moose!

On Form_Open event put this code.

DoCmd.GoToRecord acDataForm, "formName", acNewRec

 

[moose]

I tried your solution by changing "FormName" to the name of my subform and main form (not at the same time) but neither worked.
Should the code go in the onopen event of the main form?

 

[MStef]

Yes, put it in main form.

 

[moose]

I have done that but the focus is still on the 1st record