Linking subforms for 3 different tables

M

Marte Cabello

Hi,

I'm trying to get 3 tables linked in a single form, but it seems like I made
something wrong, because two forms work OK, but the one that calls them
brings the form, lets me fill in the information, but when I call it back, it
shows up empty again. The records can be retreived, but I don't know what I
did.

Any good tutorial or reference to go over so I can see how to correct this?

Thanks
 
A

Amy Blankenship

Could you be more specific about how the tables used in the forms are
related and what you are trying to do?

-Amy
 
M

Marte Cabello

I have a table three tables:

1- master document data
2- Review data (multiple reviews per master data)
3- Observations per review (multiple observations per review)

What I'm trying to do, is to include a form to enter the master data, that
links to a second form (linked through a button) that has the review form,
and the review form has a third form embedded as a subform. The review and
observation form works fine, but when the master data calls the review form,
it is not asigning the data to the master document. I know the relations are
set accordingly, but I think I missed a piece of code on the master data
button that calls the review form.

I am trying to get maybe a good book or a tutorial to link forms, because I
am using the form wizzard as a source, but I think I'm missing a part of the
code.

Thanks
 
A

Amy Blankenship

Have you tried just embedding the "child" forms as subforms instead of just
calling them?

If that won't work, what code are you using in the event procedure that
launches each of the other forms?

-Amy
 
Top