Linking subforms for 3 different tables

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
Could you be more specific about how the tables used in the forms are
related and what you are trying to do?

-Amy
 
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
 
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
 
Back
Top