Can't edit in a form with a subform

[Guest]

My database tracks video shot by my videographers. I have a form called
TapeEdit that has all the general tape data in it from a similar table,
TapeData. This form also contains a subform of Shot Descriptions on that
tape that comes from a separate table, ShotDesc. The necessary data from
both tables are combined in a query that serves as the control source for
this form. Both tables contain a field TapeID and share a one to many
relationship (1 tape, many shot descriptions).

Problem is: When the TapeEdit form is opened with tape and shot description
data, none of the data in the main form (containing the Tape information) can
be edited, but the Shot Descriptions can.

On Both Forms (Main and Subform);
Allow Filters, Edits, Deletions, and Additions Properties are set to Yes
Data Entry is set to No
Record Locks is set to No Locks

What needs to change.

 

[John Vinson]

My database tracks video shot by my videographers. I have a form called
TapeEdit that has all the general tape data in it from a similar table,
TapeData. This form also contains a subform of Shot Descriptions on that
tape that comes from a separate table, ShotDesc. The necessary data from
both tables are combined in a query that serves as the control source for
this form. Both tables contain a field TapeID and share a one to many
relationship (1 tape, many shot descriptions).

Are you basing both the FOrm and the Subform on the same query? If so,
that's probably the root of the problem. The Form should be based on
the TapeData table (or a query selecting and/or sorting records from
the TapeData table); the Subform on the ShotDesc table. Use the
linking field as the Master/Child Link Field. It's neither necessary
nor appropriate to bind either form to *both* tables.

John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps