I have a pass-through query that is used to look up charge detail in a SQL database and I am connected via odbc. I would like to know is someone can help me speed up the loading of the form which uses this query. Once the form is loaded is works quite rapidly, however on initial loading there is at least a 15-30 second delay. The table the pass-through is coming from has about 40k records.

Any suggestions?

Thanks,

Mr. Research