Query Subform

C

cmichaud

So i have a query as a subform. It is implanted in the form that i am
using to enter the parameters for the query.

the query sql is
SELECT tblClubInfo.Name, tblClubInfo.Leader, tblClubInfo.ContactPhone,
tblClubInfo.ContactEmail, tblClubInfo.MeetingPlace,
tblClubInfo.MeetingOccurance, tblClubInfo.SexesID, tblClubInfo.AgesID,
tblClubInfo.CityID
FROM tblClubInfo
WHERE
(((IIf(forms!frmclubsearch!agesID="(All)","",tblClubInfo.AgesID=forms!frmclubsearch!AgesID))<>False)
And
((IIf(forms!frmclubsearch!CityID="(All)","",tblClubInfo.CityID=forms!frmclubsearch!CityID))<>False)
And
((IIf(forms!frmclubsearch!SexesID="(All)","",tblClubInfo.SexesID=forms!frmclubsearch!SexesID))<>False));


the form functions fine in that it and the query work. however when i
run the search the subform doesnt update.....instead a new query
display window opens and displays the results. i want it so that when
i enter the values on the form and hit search (running the query macro)
that it will display the results in the query subform and then allow me
to immediatly run a new search with different variables. any idea
howto do this???
 
Top