Subform query

[MadCat]

Hi all

I have a main form on which i have a subform whose record source is a query which counts records which fall between a start date and an end date. The query works fine if i just use the standard prompts that access provides. Ideally i want the user to enter the two dates into unbound text boxes on the subform and click a button that will refresh the query result. The problem that i am having is when i load the main form. Initially the query looks for the parameter values of the startdate and enddate text boxes. Is there a way that i can have the main form start up and ignore the query until the text boxes are populated by user input.

Hope this makes sense

Thanks in advance

 

[WayneRyan]

MadCat,

You can have the Main Form assign the Record Source to
the subform and then do a Requery.

Wayne