Command button - add entry - getting error.

I get the error: can't go to specified record.

I am using the form to enter production numbers.

This is the code created when I used the command button wizard:

Private Sub Command32_add_entry_Click()
On Error GoTo Err_Command32_add_entry_Click


DoCmd.GoToRecord , , acNewRec

Exit_Command32_add_entry_Click:
Exit Sub

Err_Command32_add_entry_Click:
MsgBox Err.Description
Resume Exit_Command32_add_entry_Click

End Sub

-- Thanks!!
Bonni

The first thing that comes to mind is that the form's Allow Additions is set
to NO. Go to the form's Properties Box, click on the Data tab and set it to
YES. IF you want users to be able to edit or delete records, make sure
AllowEdits and AllowDeletions are set to YES also. There are other ways (in
code) that the form could be set to not allow additions, but, assuming thisis
your db abd not inherited from someone else, you'd know if you'd coded this.

--
There's ALWAYS more than one way to skin a cat!

Answers/posts based on Access 2000

Message posted via http://www.accessmonster.com

Thanks I'll try that.

Unfortunatly this is part my db and part inherited. The original author was
a programmer and wrote quite a bit of VB into the db. This form is all me
so it is pretty basic.
--
Bonni


"missinglinq via AccessMonster.com" wrote:

The first thing that comes to mind is that the form's Allow Additions is set
to NO. Go to the form's Properties Box, click on the Data tab and set it to
YES. IF you want users to be able to edit or delete records, make sure
AllowEdits and AllowDeletions are set to YES also. There are other ways (in
code) that the form could be set to not allow additions, but, assuming thisis
your db abd not inherited from someone else, you'd know if you'd coded this.

--
There's ALWAYS more than one way to skin a cat!

Answers/posts based on Access 2000

Message posted via http://www.accessmonster.com

I checked the Allow additions and it is set to yes. Anything else I can try?
thanks
--
Bonni


"missinglinq via AccessMonster.com" wrote:

The first thing that comes to mind is that the form's Allow Additions is set
to NO. Go to the form's Properties Box, click on the Data tab and set it to
YES. IF you want users to be able to edit or delete records, make sure
AllowEdits and AllowDeletions are set to YES also. There are other ways (in
code) that the form could be set to not allow additions, but, assuming thisis
your db abd not inherited from someone else, you'd know if you'd coded this.

--
There's ALWAYS more than one way to skin a cat!

Answers/posts based on Access 2000

Message posted via http://www.accessmonster.com