I have a main form and a sub form. so, when i am trying to load the main form its asking me the parameter value.
If i run the sub form itself (not placing that in main form)-its working good.
I am trouble having this issue.
Please help!
I have a main form and a sub form. so, when i am trying to load the main form its asking me the parameter value.
If i run the sub form itself (not placing that in main form)-its working good.
I am trouble having this issue.
Please help!
does the subform query have params?
are they spelled correctly?
does the subform box point to the correctly spelled subform or query?
is it a crosstab query...(they ALWAYS must have params entered in the query design)
Yes,my sub form has a query= SELECT Accident.AccidentNo, Accident.AccAddrLink, Accident.AccJurid, Accident.OwnerLink, Accident.AccDate, Accident.AccTime, Accident.CorrectiveActions, Accident.AccSource, Accident.AccDateRec, Accident.AccSummary, Address.MicipalityLink, Municipality.CountyLink, Municipality.TwnVillCity, Accident.AccOrInc, Accident.AccDateClosed, Accident.AccDateClosed2FROM Municipality INNER JOIN (Address INNER JOIN Accident ON Address.AddressNum = Accident.AccAddrLink) ON Municipality.MunicipalityNum = Address.MicipalityLink;
everything is spelled correctly.
I think it might be because the sub form is loading before the main form. if this is the reason, what should i do now.?
1) Check the Master/child field links..
2) Post your dB......