Form with 2 Subforms

[RodgerDJr]

OK I know I should be able to do this.

I have a form (Software Title) with two subforms what I want to do is have Subform1 (Software Version) change Subform2 (License Information).

I have an unbound filed on my main form that changes according to what the ID for Version I am working with. Now I need to set the Parent and Child link for the License Information. This is where I am banging my head and I know I am missing something easy.

TIA,
Rodger

 

[gemma-the-husky]

i do stuff like this, this this way

you may link the parent to one of the subforms, or not
any way, have a variable somewhere set by the first subform, and have the query for the second form dependent on it
you can put the variable on the parent form, if you like - sometimes its useful to see the value there

then in the first subform you can say, in the current event

myvariable = whatever 'so the second subform query will calculate properly
(or maybe parent!variablefield = whatever)
parent!secondsubform.requery 'do the recalc

you may need some special handling for empty datasets (ie no records in subform 1


---------
you can nest subforms, but this is no good if both subs are continuous - which may be your situation