Can't add new record?

[lution]

I'm using Access 2007 and have a datasheet form setup on one of my tables. If I start with no records in the table, when I open the datasheet view I can't create more than one record. Once I've put anything in for the first record and exit the form and then come back, I can add records all day long. When the form is first displayed with no records the * row isn't displayed, the record navigation controls on the bottom are all enabled but even if I click on the New Blank Record control a new record isn't created.

For form properties I don't have a filter, the data is ordered by the primary key. AllowFormView = No, form is PopUp = No, Modal = No.

I've looked through my VBA and don't see anything keyed to restricting the ability to add a new record. I don't get any errors when the datasheet is displayed. Anyone have any ideas on what else I can look at that might cause the issue? I can post the onload vba if it would help.

 

[lution]

I don't have any explicit permissions setup so its not an access rights issue. I've checked to make sure that add and edit are set to yes for the form and the recordsource is a single table. So it's not any of those.