Read only field on Split form

[casinc815]

I have a split form based on a query. The query is based on five tables.
The main table stores all information and the four remaining tables are
the joins for reference and integrity.

I have an Add Record button on the data portion of the split form. In the


event procedure, I created an INSERT statement that inserts blank data
records into the main table. All of this works.

The problem appears to be in the data entry. When the Add Record button
is depressed and the event fires, a blank record is inserted but the field does
not allow for data entry. It appears to be Read only. I can navigate through
out the form, no problem. I simply cannot enter data.

Now if I remove the Add Record button, and add data from outside of the split form
everything works well. No problems with the form or table. Data entry works.

The preference is to allow the user to be on the desired splitform and add a row
to the datasheet of the split form when they need it. The way it works now
is to close the split form, go to the form that adds records to a table, leave that form
and reenter the split form and continue to work.

Has anyone seen this before? Anyone know how to investigate controls that are read only on a form?
What converted the fields to read only? Any ideas?

Jim

[casinc815]

A SOLUTION HAS BEEN FOUND!!!

We created a split form with the datasheet on the bottom. Control exist on the top portion of the
form for data entry. Control buttons have been added to the form for navigation and a special control
button was added to allow for the addition of blank records.

When the blank record was added, the addition was correct but it left the form read only or not updateable.

A few minutes ago, I was reading a posting where the author stated the exact same problem.
It appears that when the forms are created, the Recordset Property is left at its default, DYNASET.
With the addition of a blank record, the form did not perform. The Recordset was changed to
DYNASET (INCONSISTENT UPDATES) and all is well. Life is good for the author.

Thanks to everyone that took a look at this posting.

Jim