I have a query that I am trying to create a subform and place on a main form. When I create the subform it works fine but when I place it on the main form it will not show and gives the error that the form is not bound. When I try to create the subform from a query, the fields of the query are not available to select. Could you please help me figure out what I am doing incorrectly?
my query:
PARAMETERS [Forms]![frmWorksheetWT]![cboWSProjSel] IEEESingle;
SELECT Sum(Nz([NP])) AS NPR, Sum(qryMH_PSCT.PL) AS PLR, Sum(Nz([SW])+Nz([SF])) AS STEEL, Sum(Nz([PF])+Nz([PW])) AS PIPE, Sum(Nz([OM])+Nz([IM])) AS MACH, Sum(Nz([EL])) AS ELEC, Sum(Nz([RG])) AS RGG, Sum(Nz([CP])) AS CARP, Sum(Nz([DK])) AS DOCK, Sum(Nz([NP])+Nz([PL])+Nz([SF])+Nz([SW])+Nz([PF])+Nz([PW])+Nz([OM])+Nz([IM])+Nz([EL])+Nz([RG])+Nz([CP])+Nz([FW])+Nz([DK])) AS TOTAL
FROM qryMH_PSCT
GROUP BY qryMH_PSCT.WEstProj
HAVING (((qryMH_PSCT.WEstProj)=[Forms]![frmWorksheetWT]![cboWSProjSel]));
my query:
PARAMETERS [Forms]![frmWorksheetWT]![cboWSProjSel] IEEESingle;
SELECT Sum(Nz([NP])) AS NPR, Sum(qryMH_PSCT.PL) AS PLR, Sum(Nz([SW])+Nz([SF])) AS STEEL, Sum(Nz([PF])+Nz([PW])) AS PIPE, Sum(Nz([OM])+Nz([IM])) AS MACH, Sum(Nz([EL])) AS ELEC, Sum(Nz([RG])) AS RGG, Sum(Nz([CP])) AS CARP, Sum(Nz([DK])) AS DOCK, Sum(Nz([NP])+Nz([PL])+Nz([SF])+Nz([SW])+Nz([PF])+Nz([PW])+Nz([OM])+Nz([IM])+Nz([EL])+Nz([RG])+Nz([CP])+Nz([FW])+Nz([DK])) AS TOTAL
FROM qryMH_PSCT
GROUP BY qryMH_PSCT.WEstProj
HAVING (((qryMH_PSCT.WEstProj)=[Forms]![frmWorksheetWT]![cboWSProjSel]));