long proccess time when sending SQL string to form record source

[thread]

Hi

i built a form that getting dynamic SQL string,the SQL string is
placed in the record source when the form is opened.
i notice when trying to reduce some proccess time from the form that
it takes quite alot of time for the SQL string to be pass to the form
record source
i guess one of the reasons depend on the size of the data as well
but is it posible to reduce the proccess time during this action?

[lyle fairfield]

Setting the record source should be instantaneous.

If you're using a modern version of Access the number of records loaded is
probably restricted. Regardless, the size of the data will not affect the
setting of the record source.

Perhaps, you are doing something in an inefficient way. If you post the
code (all the code) that sets the form's record source then someone may
make a suggestion.

thread <ya******@gmail.comwrote in news:7b45c0f4-4be4-4d74-8120-
19**********@l42g2000hsc.googlegroups.com:

Hi

i built a form that getting dynamic SQL string,the SQL string is
placed in the record source when the form is opened.
i notice when trying to reduce some proccess time from the form that
it takes quite alot of time for the SQL string to be pass to the form
record source
i guess one of the reasons depend on the size of the data as well
but is it posible to reduce the proccess time during this action?