subform new record

[Blackwidow]

I have a subform that I want to automatically go to a new record but I dont want a data entry screen as they need the previous as well.

I've tried putting DoCmd.GoToRecord , , acNewRec on the form open command that doesnt work.. tried it on the onload()..

I thought this was going to be really obvious but after searching the forum I have found others with the problem but no one has given a solution?

Is this not possible?

 

[Oldsoftboss]

On the main form, put me.subformname.setfocus first. Then docmd.GoToRecord,,AcNewRec

 

[Blackwidow]

put it on the main form where?

 

[Oldsoftboss]

Sorry, In the On_Load event with the other code

Private Sub Form_Load()

Me.SubformName.SetFocus
DoCmd.GoToRecord,,AcNewRec

End Sub

 

[Blackwidow]

got it to work

I took your message a little too literately and put
me.frmPerformance.setfocus first.

Then docmd.GoToRecord,,AcNewRec

but i realise now that the "first" was an instruction to me not coding! I am having a really bad week!

It works brilliantly thank you!

 

[Oldsoftboss]

Glad to help

 

[scottappleford]

Thanks

was just about to ask the same question