Add record in Subform problems

[EddyLLC]

have two forms, each with a subform displayed in datasheet view. Each
subforms control source is a table with three (3) key fields. When I open
one of the forms I can add a second record in one of the subforms key
fields and the other 2 key fields are automatically filled in with the same
data that is in the first record thus I can save the second record. On the
second form filling in one of the key f ields on the sub form does not
automatically put data in the other 2 key fields thus I get a duplicate of
blank key field or indexed field error. Can anybody tell me why? The tables
and forms are virtually identically in format.

 

[PHV]

Double check the LinkMasterFields and LinkChildFields properties of the subform controls.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[EddyLLC]

Thanks for the response. The LinkMaster and LinkChild fields are identical in both forms. The reference the same fields as they should.