Forms with external queries taking a long time to display

[chris.williams]

I have a form with a search field which performs a lookup on a query to a MySQL DB.

The problem I am having is that each time I load the form (it has other functions as well), it is taking a long time to load as I am assuming it is running the query.

How do I only run the query when I have a need to and not every time the form loads?

[rpeare]

This sort of impossible to tell you. When you open the linked SQL table itself, does it open quickly or slowly?

If you were to run a query (the same query on your form) without opening your form does it run quickly or slowly?

If your form has list boxes or combo boxes that involve querying the SQL tables it is flat out going to take time depending on how large the source tables are. if they are all short tables and it's taking 3 minutes to open there's likely something wrong in the code for the on load or in the objects themselves.

[chris.williams]

The remote DB is over a variable speed line and connectivity can be great or not.

The form has a subform which is hidden when the form is first displayed. Then a query is run and then the subform is displayed. The query is run based on text entered into a search field. With the search field blank, the query returns all records (but again the subform is hidden).

What I would like to do is have the query run only on click command, rather than populating when the primary form is run. I suppose I could open a new window, but then that would take away the look and feel.

[rpeare]

without an example of what you're talking about I don't think I can offer much help. You can create a sample database but instead of having the linked tables make them local tables and put in some fake data to play with then zip up a copy of it and load it here.