I have a main form contains two sub forms created in MS Access. There are two text boxes on the main form. After the user enters the start and end dates in the text boxes, and click on the search button, the information in these two sub forms should
be recalculated and refreshed the results on the sub forms and show within the main form.
Once, I changed the data source of a sub form with a crosstab query and saved it. I don’t know whether it is the problem coming from. Now, after the user enters the dates, and search the result, this
crosstab query result opens by itself first before the main form with two sub forms open.
I have deleted the record source of the sub form from the property, and assigned the record source for the sub form in the search button by code. But it
didn't solve the problem.
How can I stop the crosstab query to pop up? Thanks.
