Sub form opens before the main form in MS Access

Access Discussion in 'Microsoft Office' started by Jane Y, Jul 13, 2018.

  1. Jane Y

    Jane Y

    Joined:
    Jul 13, 2018
    Likes Received:
    0
    Hi,

    I have a main form contains two sub forms. There are two date text boxes on the main form. After the user selects the start and end dates, and clicks on the search button, the information in the two sub forms should be recalculated and refresh the results on the sub forms. Once I changed the data source for one sub form and saved it. I don’t know whether it costs the problem. Now, after user selects the dates, and search the result, one of the sub form opens by itself first with correct result. After the user close this sub form, the main form with two sub forms display with the correct results. How can I stop the first sub form shows, just show main form with two sub forms together?

    Thanks.
     
    Jane Y, Jul 13, 2018
    #1
    1. Advertisements

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.