Two Forms

[Larry]

I have a "parent" table and a "children" table. They are linked via a
"parent ID" that is an AutoNumber. One parent can can have many children.

Now I am trying to make two forms, and "Add New Parent" form and an "Add New
Child Form", the "Add New Parent Form" has a button at the bottom that saves
the current form then opens the "Add New Child Form", the parentIF field is
populated from the "Add New Parent" form automatically. The problem comes
when I try to save the new child, it get an error that says a corresponding
record is needed in the parent table, eventhough it is already there.

Any help with this would be greatly appreciated!

 

[Larry]

Thanks man - sometimes I just over complicate things...

 

[Tom van Stiphout]

On Tue, 24 Jun 2008 07:02:01 -0700, Larry

It appears that the step "the parentIF field is populated from the
"Add New Parent" form automatically" is not working as well as you
expected.

More commonly this is all done on one form: design the Parent form,
then drop a subform control on it while the control wizard is on,
select your child form, set the LinkParentField, LinkChildFields, and
you're done. No code needed.

-Tom.