[AccessD] Conditional subforms

jwcolby jwcolby at colbyconsulting.com
Thu Jun 18 20:50:32 CDT 2009


yep, works like a charm.

John W. Colby
www.ColbyConsulting.com


Stuart McLachlan wrote:
> My standard way of doing this doesn't need any code, just:
> 
> 1. Create a hidden textbox on the parent form "txtsubForm1Link" and set its source to  "= 
> frmsubForm1.Form!fldPK"
> 
> 2. Set the "Link Master Field" of subForm2 to "txtsubForm1Link" and the "Link Child Field" 
> to the foreign key in Form2.
> 
> It's all automagic from then.
> 
> I often do this to several levels of cascaded continuous forms on an unbound parent form 
> where there is a need to maintain the data in a hierarchy of related tables.
> 



More information about the AccessD mailing list