Open Form in new record docmd.goto acNewRec

[pkarnowski]

I still can't get this to work, I have tried adding it to the on open [event procedure] but get errors. Where do I add it?

Private Sub Form_Open(Cancel As Integer)
docmd.goto acNewRec
End Sub

This is what it looks like when I add it.

 

[SydneyGeek]

If you ALWAYS want the form to open on a new record, go to the Properties of the form and change Add to True.

Denis

 

[pkarnowski]

Denis, That's what I want bu cannot find ADD, I have searched through all the properties.

 

[SydneyGeek]

Paul, I'm at work at the moment and don't have Access on this machine -- I may have remebered the item incorrectly. I'll get back to you when I've checked it out.

Denis

 

[SydneyGeek]

Paul, I dug through my resources and the Help section, and it was very unhelpful. Basically, I couldn't find how to set defaults so that a form opened in New Record mode, or to control that setting from the same form. I'd be happy to be proved wrong on this one, but I think the only approach you have is to open the form from a Command Button on ANOTHER form:

Private Sub Command1_Click()
  DoCmd.OpenForm "Invoices", acNormal
  DoCmd.GoToRecord , , acNewRec
End Sub

Sorry -- don't know why they made this bit so hard.

Denis

 

[Andrew Fergus]

I'm not sure if this is going to help or not but you can change the "Data Entry" property of the form to "Yes" which will make the form default to a new record every time you open the form. However, the limitation is that you can't use the form to edit or delete existing records - you can only use the form to add new records.

Andrew

 

[Corticus]

Nice, Andrew.

That's useful, I've always used the method SydneyGeek decribed.

 

[pkarnowski]

Thank you, that worked