Sorry, basic forms question

[Mike Morton]

I've searched back through the posts for an answer, but can't come up with
anything.

How can I open a form and automatically put it into 'Create New Record' mode
without setting it as a 'data entry' form ?

I know it's going to be something obvious that I've missed, so please be
gentle with me

Thanks

Mike

 

[Brian Bastl]

in the form's On Load event procedure:

DoCmd.GoToRecord , , acNewRec

HTH,
Brian

 

[Rick B]

Put the following in the form's open event:

DoCmd.GoToRecord,,acNewRec

 

[Mike Morton]

Ahhh yes, I *knew* it was going to be something obvious that I'd missed.

Thanks very much for that gents.

Mike