| re: ComboBox source query: run at Form_Open
As far as I know, what you propose will not speed up your combo box at all,
and in fact will slow your overall operation, because the ComboBox will run
its Row Source query when it is initialized, whether or not that query has
already been executed.
Larry Linson
Microsoft Access MVP
"Jean" <jeanjanssens@hotmail.com> wrote in message
news:1126007317.976413.104650@g49g2000cwa.googlegr oups.com...[color=blue]
> Hi,
>
> I think this is quite a simple one:
>
> I have a ComboBox, where the source is a stored query. When I click the
> drop-down arrow on the Box, it takes awhile. I want to run this query
> in the background when the form opens, so that when I click the
> dropdown, it is ready.
>
> How?
>
> Thanks, really appreciate it.
>
> J
>[/color]
| 
