new record on form open

[seeker]

I would like a form to open in a new record. How can that be done.

 

[KARL DEWEY]

Set the Data Entry property to Yes.

Bear in mind that this will only allow entering new records, no viewing or
editing.

 

[Douglas J. Steele]

For the form's Load event, use code like:

Private Sub Form_Load()

DoCmd.GoToRecord, acActiveDataObject, Me.Name, acNewRecord

End Sub

 

[Access WannaBe]

This works great with Access 2003, but when I try it with Access 2007 it
gives me a VB error. I've tried several different metthods, each give me a
VB error.

 

[Douglas J. Steele]

What error(s) are you getting? (pretty hard to diagnose problems without
knowing...)

 

[Larry Linson]

What error(s) are you getting? (pretty hard to
diagnose problems without knowing...)

What's the matter, Doug, did you let your membership to "Access Psychics"
lapse? <GRIN>

Larry

 

[Douglas J. Steele]

What's the matter, Doug, did you let your membership to "Access Psychics"
lapse? <GRIN>

I had to make a decision. I couldn't handle being in both "Access Psychics"
and "Access Psychos". <g>

 

[John W. Vinson]

I had to make a decision. I couldn't handle being in both "Access Psychics"
and "Access Psychos". <g>

Oh no... we've gone on from being junkies to being psychos!

We're up to six or eight Normal Forms - do we need a twelve-step program
instead?

 

[Access WannaBe]

Visual Basic Run-Time Error--you can't go to the specified record.

I changed the code to:

Private Sub Form_Load()
DoCmd.GoToRecord , , acNewRec

End Sub

It works great with Access 2003, but I get the run time error with Access
2007.

I make fun of people when they come into my store and expect me to read
their mind....I now know how it happens. I'm glad to see everyone has a good
sense of humor, but are you still willing to help me.

Thanks.
Chad

 

[Douglas J. Steele]

Are you sure the form's updatable? If it isn't, you can't go to a new
record.

 

[Access WannaBe]

It was a "read only" setting on a network forlder. Thanks for your help.