Let’s say that A is the mainform. B and C are subforms each within A. Neither B nor C are subforms within the other. Is it possible to create a Master/Child relationship in which a field within B is the Master and a field within C is the child?
If so, is it possible to accomplish this if both B and C are displayed in Datasheet view?
Thanks,
Justin
Last edited by pilotwings64; 08-20-2010 at 09:46 PM.
GalaxiomAtHome from Microsoft Access Help Center (http://www.access-programmers.co.uk/forums) offered this solution.
“Place a textbox on the mainform with the control source as the subform field you want as the Master (=Forms!mainform.subformB.Form.fieldname). Then set this textbox as the MasterLinkField of the other subform control.”
I tried, this and it linked the text box to the desired field in subform B but I can’t find a way to link subform C to that text box using a master/child relationship.
Does anyone know how I can complete this final step?
Thanks again,
Justin
mike60smart at UtterAccess.com walked me through the process. The thread has the same name as this one (maybe I named it Parent/... instead of Master/...).
Basically, I just had to do the master/child linking in the properties panel, by tying the links in, since the dialog box and dropdown menu were not offering me the option.
Hope this helps anyone with the same problem.
Justin
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks