openform

[SueM]

Hi,

I have a form with a control button on. Attached to the
control button is an on click event which opens another
form using the following command

DoCmd.OpenForm "Form1"

When Form one opens it contains some of the details from
the previous form.

Is there a way in which I can add a line to this event
which will force Form1 to open to a new record each time?

Cheers

Sue

 

[Steve Schapel]

Sue,

DoCmd.OpenForm "Form1", , , , acFormAdd

.... or...

DoCmd.OpenForm "Form1"
DoCmd.GoToRecord , , acNewRec

- Steve Schapel, Microsoft Access MVP