Problem using Parent/Child Form/Subform

[EvanRosenlieb]

I posted this as an addendum of a previous thread of mine but I believe it is more appropriate in this section. I am an access newbie and I'm sure there is an easy answer to this:



The data that gets entered in the parent form shows up as a record on the parent table, and the information that gets entered into the subform gets entered as new records in the child table. However the ParentID field in the child table remains blank. I would like the ParentID field to automatically add the ParentID of the record that is being added into the child table... Surely there is a way to do this?
Thanks,
-Evan

[RuralGuy]

If this field is both the MasterField and the ChildField of your SubFormControl then Access will complete it for you in the SubForm.

[EvanRosenlieb]

The book I am working off of seemed to imply that if there was a relationship at the time you set up the form/subform then it would just automatically work. After manually setting these fields in the property tab, however, it worked perfectly.

-Evan

[RuralGuy]

It sounds like the book was just a bit unclear on the subject. Glad we could help.

[boblarson]

The book I am working off of seemed to imply that if there was a relationship at the time you set up the form/subform then it would just automatically work. After manually setting these fields in the property tab, however, it worked perfectly.

-Evan

Actually, usually it will set it up for you automatically if you choose the right option when you place the subform on the form. So, either your Wizard was disabled (magic wand button not depressed when dropping it on the main form) or perhaps your database didn't have the trusted location set or code enabled when doing it.