Opening Forms to a new record

[vlew]

I am trying to set up a short cut to the desktop so that when accessed a specific form opens up to a new record. Currently it always opens to the first record.

 

[Orion45]

I think there's two ways you could do this. First you could set the data property of the form to allow data entry. Or, if you are using a button to open the new form try adding the acFormAdd to the code. For example,
DoCmd.OpenForm stDocName, acNormal, , , acFormAdd
This is the way I would recommend. Hope it works for you.

 

[jebry]

Hi!

Another way would be in the Load event procedure use the following code:

DoCmd.RunCommand acCmdRecordsGoToNew

This will open the form to a new record and still allow the user to view existing records.

This can also be done in a macro using the RunCommand Action.

hth
Jeff Bridgham
bridgham@purdue.edu