Updating a subform from within _root_form

[Shoji]

So here's the situation:
I have two tables I want to use. Both are linked to forms.

The first table/form contains detailed information, including information outside viewers don't need to know (social, for example). The second table/form has just basic information (name, dates, etc).

What I tried doing:

I have the first table/form in view, the second table/form I have as a subform. This subform automatically changes from record to record the same as the top form. What I was trying to do was run a macro/vbcode that updates the subform fields as the fields on the first form/table is updated or changed.



The problem:

MS Access 2003 considers all sub-forms as not even being open. So that means I can not reference to or change fields in a subform from the root form (or first form).

Anyone know any possible solutions?

[ScottG]

Are the 2 tables linked via a unique ID field? If so you can just link the subform to the Parent form through the "Link Child Fields" & "Link Parent Fields" in the Form Properties.

If the 2 underlying tables aren't linked then it will have to be done using programming but there will still need to be some data in common so you can re-query the subform based on the data in the main form.

Thanks,
ScottG