avoiding long requeries

[dennisem]

I am trying to avoid long odbc re-queries on the same the same data when the same query is referenced as a data source for different forms. It is not clear to me if the query will execute twice if two forms are opened simultaneously or if the second open can access the data without re-query.
dm

[pbaldy]

I'm pretty sure it will execute twice. Why two forms based on the same query? Can you restrict the recordset?

[dennisem]

Thanks for the reply, Paul. Yes I can restrict the record sets which are not terribly large. However, searching a large number of records and sending the same data through the network twice, strike me as much less efficient than accessing data directly from a locally open data set. I am concerned with introducing processing speed issues down the road in my approach to query design. I guess I have become somewhat paranoid about timing issues from discussions I have followed on odbc timing.
dm