query subform

[bigmac]

hi all,
a don't know if this is the right place for this one but here goes.
i have two forms frm1 and subform 2,
if i open subform 2 on its own and click on a row of data in any field and open the query it shows me the info on that field only (which is what i want to happen), BUT if i open frm1 with subform 2 attached then try the same thing then it asks
for parameters, all i want is for the query to work on the subform when used through frm1 both are joined in a one to many via welder id (primary) and welders id on subform both work great except for this issue, help please

 

[Pat Hartman]

You can't have it both ways with the same query because the form field reference will be different depending on whether the form is a main or sub form.

Where SomeField = Forms!frmMain!controlName

Where SomeField = Forms!frmMain!sfrmSub.Form!controlName

 

[Simon_MT]

Try the constructing the the forms the other way round.

Put the data in Form 2 in the detail and the information in Form 1 in the header and qualify the data in Form2.

Simon