Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Forms / December 2005

Tip: Looking for answers? Try searching our database.

Linking subforms for 3 different tables

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Marte Cabello - 06 Dec 2005 18:11 GMT
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
Signature

M

Amy Blankenship - 06 Dec 2005 18:20 GMT
Could you be more specific about how the tables used in the forms are
related and what you are trying to do?

-Amy

> Hi,
>
[quoted text clipped - 11 lines]
>
> Thanks
Marte Cabello - 06 Dec 2005 20:56 GMT
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
Signature

M

> Could you be more specific about how the tables used in the forms are
> related and what you are trying to do?
[quoted text clipped - 16 lines]
> >
> > Thanks
Amy Blankenship - 07 Dec 2005 00:02 GMT
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

>I have a table three tables:
>
[quoted text clipped - 42 lines]
>> >
>> > Thanks
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.