Originally Posted by
June7
...Makes no sense to have main form and subform bound to the same data...
June7 is right! A Form/Subform from the same RecordSource will mean that one of the Forms will not be editable, since you have the same Record open twice, in different Forms. If you try to get into Editing the Records, you'll also start having Write Conflicts, always a hairball to sort out!
When you create a New Record in the Subform, the Field named in the Subform Control's LinkChildFields Property normally inherits its Value from the Field named in LinkMasterFields. Typically, Access will assign the Primary Key Field to these Properties. If the Record on the Main Form is not at a New Record, the Subform will try to use the same Primary Key Value as the Record in the Main Form, and since they are both using the same Table, you'll probably get the Error Message:
The changes you requested to the table were not successful because they would create duplicate values in the index, primary key, or relationship
June7's suggestion of a Split Form really sounds like the way to go!
Linq ;0)>
The problem with making anything foolproof...is that fools are so darn ingenious!
All posts/responses based on Access 2003/2007