Open Form with "new record"

[StephenSLR]

I have set up a form like a web page with a "Next >" button to close the current form and open a new form.

Is it possible to have the new form open and be ready to accept a new record instead of having to hit the "Create a new record" [>*] button?

s

 

[Pat Hartman]

Instead of opening it in normal mode, open it in add mode.

 

[ghudson]

DoCmd.OpenForm "YourFormNameHere", , , , acFormAdd

 

[StephenSLR]

Instead of opening it in normal mode, open it in add mode.

How is this done?

I have set up form1 with a command button to open form2.

Also, how would I have form2 open in add mode?

s

 

[ghudson]

How is this done?

I have set up form1 with a command button to open form2.

Also, how would I have form2 open in add mode?

The answer is about five inches above your last question.

 

[Rich]

The button wizard will create the code for you

 

[StephenSLR]

DoCmd.OpenForm "YourFormNameHere", , , , acFormAdd

I have added this into the "on Click" properties for the form button.

The Record counter at the bottom of the new form says

"Record: 1 of 1"

though there are more than one records in the table.

Is this how it should look?

s

 

[StephenSLR]

Also I would like to have the "start up" display form open up ready to add a new record as well.

How is this done?

s

 

[Pat Hartman]

Change the form's DataEntry property to Yes.

 

[StephenSLR]

Change the form's DataEntry property to Yes.

thanks.

s