Can't Add New Record

[Guest]

Hey,

I'm designing an Access form in Access 97. I've turned off the default
record navigation buttons in place of some custom buttons that should perform
the same function. I created these two buttons using a wizard, and specified
that they would let me move forward and backward in a recordset.

I have one record in the database now. However, when I click the button to
go to the next record (which is blank), I can't enter any data. I get the
following message:

"You can't go to the specified record (you may be at the end of the
recordset)"

This is weird. Basically, it's letting me move backward and forward through
any existing records, but won't let me add a NEW record.

What's up??!??

 

[Rick B]

Have you checked the "allow additions" property of your form?

 

[Guest]

It's set to "Yes".

Have you checked the "allow additions" property of your form?

 

[Guest]

Simsjr,
I encountered a similar problem and here is the fix found in the help files.
Hope it works.

I was not able to add a new record on my subform. Source was based on three
queries or tables in which there is a many to one to many relationship.

Solution
Change the Form's Recordset Type property to Dynaset (Inconsistent Updates).

David Peterson