Access 2007, all subforms read-only

[Merganser]

I've converted an application from Access 2003 to Access 2007. Everything was looking good until I tried editing some data from a subform and discovered that all forms, when displayed as a subform, are read-only.



I tried the old version and all of the subforms work fine and I even converted the old version again and all of the subforms are working -- but I've done a lot of work on first conversion so would like to not need to start over, if possible.

This is not an issue with joins or read-only queries because some of the forms being used as a subform that are read-only are linked directly to a table. Also if a form is placed as a subform on another form, but is not linked to the master form at all, editing works. I checked the obvious (allow edits, enabled, locked, etc.)

Is there a new option in 2007 that affects subforms -- like is there an option somewhere that sets all subforms to read-only? Forms/subforms that were working no longer do so.

[Merganser]

Hi, I'm going to answer my own question -- I think that somehow the db was corrupted. I've re-converted my application and have been importing the updated VBA code and forms and everything is working now. The old version still has all subforms working as read-only but importing code -- and even forms -- does not cause the new application to act the same way.