Child and Parent field links

  • Thread starter Thread starter Annemarie
  • Start date Start date
A

Annemarie

Hello!

I have three forms....One main form with information and a choice of
Yes/No. When Yes is selected a form pops up for data entry. When No
is selected a different form pops up for data entry. The problem is
that there is no link to the parent form so the data entered is not
going to the tables. I would like to link the child and parent fields
of the forms for data input but am not experienced enough with codes to
write it myself. Can someone help me with this?

Parent fields are
[Forms]![Add New Subfunctions]![CCN]
[Forms]![Add New Subfunctions]![UIC]
[Forms]![Add New Subfunctions]![Sub #]
[Forms]![Add New Subfunctions]![Sub CCN]

Child fields for one form are
[Forms]![Algorithm YES]![CCN]
[Forms]![Algorithm YES]![UIC]
[Forms]![Algorithm YES]![Sub #]
[Forms]![Algorithm YES]![CCN Subfunction_SubCCN]

I already have an OnOpen macro that opens to a new record. Any help
would be appreciated. Thanks.

I have tried inserting a subform through the wizard, but when I do this
the subforms are always on the main form. If there is a way to use
subforms but still only have the respective form open on the click of
the Yes/No button this would be anothe option.

Suggestions??? Thanks.
 
Annemarie

A couple of ideas...

If you use a tab control, you can place your "Yes" and "No" forms, as
subform, on other pages. Clicking on your Yes/No choice could move the
focus to the appropriate page. As subforms, you can use the "plumbing"
Access offers for keeping main forms/subforms synchronized.

If you don't want to have Access keep your main and sub forms synchronized
(whether as popups or actual sub-forms), you'll have to do the work to
requery the "subform" and then requery the main form after the subform is
completed.

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
Back
Top