Crosstab always pops up before the main form opens in MS Access RRS feed

  • Question

  • 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.

    • Moved by litdev Thursday, July 19, 2018 6:13 PM
    Thursday, July 19, 2018 4:28 AM


All replies