Open a form

[deejay_totoro]

Hello,

I would like to open a form from a command button.

However, I would like the form to be ready to input a new record. For example, not to start at record number 1, but open in a state that is ready to recieve a new record.

Any help appreciated!

dj_T

 

[sagsh]

You could do the following - open your form in design view then select the toolbox toolbar icon this will open the design toolbar fom this select the command button icon and place a button on your form - then use the wizard to create a button which record operation and creates a new record - hope this helps!

Regards

Sagar

 

[WayneRyan]

dj,

Two ways:

In DesignView set the form property to DataEntry = Yes

Or

DoCmd.OpenForm "YourForm", acNormal, , , acFormAdd, acWindowNormal

Wayne