Synchronizing two subforms

[hockey8837]

Needed two subforms synchronized, one in datasheet view and the other as a detail subform of the focused record on the datasheet.

So, I followed the directions at this site:

http://www.fmsinc.com/MicrosoftAccess/Forms/Synchronize/LinkedSubforms.asp

They synchro works great in existing records and even adding subsequent new details to those existing records. But, I'm getting an error when starting from a brand new record. If the user tries to enter data into the detail subform first, and not through the datasheet, I get an error that says:

"You can't assign a value to this object.
*The object may be a control on a read-only form.
*The object may be on a form that is open in Design view.
*The value may be too large for this field"

I'm guessing this is because the details form Master-Child fields are, as per the directions in the above link: Master txtTreeWorkID, Child TreeWorkID

Whereas the datasheet Master-Child Fields are: ID, LocationID (respectively)

How do I keep the ability to focus the details subform by clicking the row in the datasheet, but also be able to begin a brand new record to the Main form's ID?

 

[gemma-the-husky]

in a "true" subform you couldn't do this - because the subform items relate (and HAVE TO relate) to an existing item on the main form.

so this implies that your form/subform link isn't set up correctly - ie doesn't represent a one-to-many relationship