 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Forms / April 2008Subform in subform
I have a mainform displaying individual info. I have a subform (form view) on the main form that displays info for assets. I have a subform (datasheet View) within that subform that references the same data but only has year and Asset name -in other words a list of assets. I want to use the list subform to select the asset and when selected the more detailed asset info in the formview is displayed. When I assign master and child properties to the individual IDs it list all assets and that is what I want it to do. But when I try to set master and child properties to sync the list subform to the other subform by asset id it will display only one asset in list form. Any help appreciated > I have a mainform displaying individual info. I have a subform > (form view) on the main form that displays info for assets. I have [quoted text clipped - 11 lines] > > Any help appreciated Think a second about which is the parent and which is the child in the subform and sub-subform. You will have to do your syncing in a different manner that the link fields. You will need some code in the sub-subform's on current event that issues a findfirst on the subform based on the primary key of the sub-subform. I suspect that this will result in an infinite loop as the subform requeries and the sub-subform then requeries, triggering a requery of the subform .... A better solution is to move the sub-subform up a level so that you have the two subforms to the main form.  SignatureBob Quintal PA is y I've altered my email address. -- Posted via a free Usenet account from http://www.teranews.com Actually, this Sub-subform shouldn't be a subform on the other subform really. It is on the same level as the other subform so it really should be on the main form and therefore the links could be the same as the other subform. SignatureBob Larson Access World Forums Super Moderator Utter Access VIP Tutorials at http://www.btabdevelopment.com __________________________________ > I have a mainform displaying individual info. I have a subform (form view) on > the main form that displays info for assets. I have a subform (datasheet [quoted text clipped - 9 lines] > > Any help appreciated |
Reply to this Message |
 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.