Open form at last record entered

[Slow Learner]

I am creating forms and when I open them they look great but always open at the first record. I would like them to open at the add new record with a pop up giving that message for a few seconds when the form opens. Is this possible and if so how do I do it? Thanks

 

[gsc_81]

Add 'new' command to form load

Putting this in the Form Load will open it ready to add a new record.

DoCmd.GoToRecord , , acNewRec

 

[Slow Learner]

Works like a charm, thanks, now I just have to get the message going and it will be complete.

 

[stephen81]

Questions like this should probably be put in the Microsoft Access Discussion section under the relevant forum (in this case probably Forms).
This forum is for people to leave samples of code that other people might find useful to put in their own databases.