Can't add new record in subform

spinkung

Registered User.
Local time
Today, 04:06
Joined
Dec 4, 2006
Messages
267
i have a relationship between a subject version (1) table and a subject cover (2) table.

1 = subject/version
2 = people trained in subject/version

the join is a composite on subjectCode and versionNo.

my main form is from table 1. i then added a subform to 2. the parent child is set up as 1.subject = 2.subject and 1.version = 2.version

i can add new records to the parent form (1) but i can;t add new records to the subform (2).

am i missing something here? can i add new records to table which have composite keys on ??

Thanks

** edit. i can open the subform on it's own and i am able to add new records.
 
Subform is not properly related to the main form or subform has a non updatable record source.
 

Users who are viewing this thread

Back
Top Bottom