Cannot update data in subform after updating from Access 2993 to 2

  • Thread starter Thread starter Mike Meacham
  • Start date Start date
M

Mike Meacham

I have a rather complex database that was created in Access 98 and updated
through the years to finally Access 2007. The last jump was from Access 2000
to 2007, I believe. Now subforms in forms cannot be edited. Once data has
been entered, if corrections are needed the row must be deleted from the
table itself before you can go back and make any corrections. It appears to
me that the table relationships are ok, and the properties table shows the
subform is editable. What am I missing?
 
I have a rather complex database that was created in Access 98 and updated
through the years to finally Access 2007.  The last jump was from Access 2000
to 2007, I believe.  Now subforms in forms cannot be edited.  Once data has
been entered, if corrections are needed the row must be deleted from the
table itself before you can go back and make any corrections.  It appears to
me that the table relationships are ok, and the properties table shows the
subform is editable.  What am I missing?
Click to expand...

Did you check the AllowEdits property of the subform?
 
I have a rather complex database that was created in Access 98 and updated
through the years to finally Access 2007. The last jump was from Access 2000
to 2007, I believe. Now subforms in forms cannot be edited. Once data has
been entered, if corrections are needed the row must be deleted from the
table itself before you can go back and make any corrections. It appears to
me that the table relationships are ok, and the properties table shows the
subform is editable. What am I missing?
Click to expand...

If the subform is based on a Query, check to see if the query itself is
updateable. I've seen changes in the updatability rules with changes in
version, it might be happening again.
 
John W. Vinson said:
If the subform is based on a Query, check to see if the query itself is
updateable. I've seen changes in the updatability rules with changes in
version, it might be happening again.
Click to expand...

I'lllog in and check that now and get right back.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Updating tables when you input new data 0
After Update event on form inputting data into a subform? 2
Retrieving data from subform 1
Updating subform on Tab Control page 0
Error message: Field cannot be updated 3
Subform as datasheet question 1
update a field in a table 1
Subform on tab control 1

Back
Top