A
Atlas
I'm working on a continuos form, whose underlying recordsource is sql query
(adp project) built around a main table, 4 "inner joined" tables, 2 where
conditions, 1 orderby.
Among the project is the slowest form to fire.
Besides this "base" complexity, unfortuantelly I also need to dlookup/dfirst
two tables 3 times per each record (two fields from one table, one from the
other); this two tables aren't joinable due to data structure (by design),
so on the continuos form, in the detail section, 3 fields are unbound and
have, as the source control, a VB function that calls dlookup/dfirst to get
the missing data.
Apart from being slow, the data inthese fields is loaded only when the form
is "idle" so it is quite noticeable a "two phase" load: the first one when
the form is drawn, the second one when the 3 fields above are loaded.
As I have read that domain functions (dfirst, dlookup) aren't so fast, I was
wondering if there's a faster method to acheive what I'm tring to do....
Could a SELECT be faster, even if seeking for a single field on a single
record on one table, and two fields on a single record on the second table?
Any suggestion?
(adp project) built around a main table, 4 "inner joined" tables, 2 where
conditions, 1 orderby.
Among the project is the slowest form to fire.
Besides this "base" complexity, unfortuantelly I also need to dlookup/dfirst
two tables 3 times per each record (two fields from one table, one from the
other); this two tables aren't joinable due to data structure (by design),
so on the continuos form, in the detail section, 3 fields are unbound and
have, as the source control, a VB function that calls dlookup/dfirst to get
the missing data.
Apart from being slow, the data inthese fields is loaded only when the form
is "idle" so it is quite noticeable a "two phase" load: the first one when
the form is drawn, the second one when the 3 fields above are loaded.
As I have read that domain functions (dfirst, dlookup) aren't so fast, I was
wondering if there's a faster method to acheive what I'm tring to do....
Could a SELECT be faster, even if seeking for a single field on a single
record on one table, and two fields on a single record on the second table?
Any suggestion?