Adding records and being able to go to previous

[BrazilTechie]

Is there a way I could prompt the user with a blank dataentry form and still give him a change to go to the previous (last) and already existing record?

I have been using:

DoCmd.OpenForm stDocName,,,,acFormAdd

Thanks in advance.

 

[THWatson]

Try opening the form with the following code behind your command button...

DoCmd.OpenForm "frmYourFormName", acNormal
DoCmd.GoToRecord , , acNewRec

This will put you on a new record, but you can still go to any other record.

Tom