Posted by Bri on 09/30/55 11:16

Neil wrote:
> Interesting. But, no, no subforms here. Just a single form displayed in
> Continuous Forms view, with a SQL comprised of linked views as a
> recordsource.

Hmm, I'm out of ideas then as to what is causing this to happen.
Fortunately, there is the empty recordset source solution to fix it. It
would still be interesting to know what the actual cause of the problem
is in case it could come up in some other scenario.

Just had another thought. I have also delt with this scenario in a
completely different way in older apps (before I thought of the empty
recordset source idea). I would have the Source selection controls in
the Form header. The initial Form is unbound but the Detail section is
Visible=False (did this to hide the #NAME# in the controls). The code
that set the Rescordsource then made the Detail section visible. I
noticed some delay on the first search, but I put it down to all of the
Combos loading their rowsources now that they were visible. Maybe this
is a similar issue to what you are seeing? It was never that extreme (10
sec for first one, 3 sec subsequent ones) so I didn't investigate
further. This was against Jet data, not SQL.

--
Bri

[Back to original message]