Subform is not inheriting ID

[Chad Access]

My subform (whose table is related to the parent) is not inheriting the ID of the parent. It is setup properly in terms of the parent - child linkages. It actually works fine on a subsequent form where the parent record has already been created.



It seems as though since the parent entry is being created, it does not inherit the id, but on the next form, it is able to inherit it because the id already exists. However, I would love for it to work right off the bat.

Hope this makes sense. Thanks for the help.

[ranman256]

you cannot enter subform children until THE PARENT IS SAVED.
The forms will let you enter a new parent and then go into the sub form to enter BUT the parent form record has not been saved yet.
It must be saved 1st in order to create the ID. THEN you can enter subform data.
you may want to disable the subform (on new record entry) ,then enable it once the master record gets saved.
then you can enter child records.

[June7]

Ranman, adding a new record on the parent form then a new record in the subform works perfectly for me. Access commits the parent record when moving to the subform and the parent ID is available. Actually, the parent ID shows in the subform foreign key field on new record row as soon as I enter data into the parent form, like a default value would show.

Would have to review the db. If you want to provide, follow instructions at bottom of my post.