M
Maury Markowitz
I have a subform that is attached to a fairly expensive query using some
derived tables. However the performance is pretty poor, because it does a
select on everything in the view and then filters down after the fact.
The query would run much faster if I could write out the SQL and put the
filter right in the WHERE "by hand". In this case the query takes
milliseconds. I do this sort of thing all the time in forms, but I'm not sure
how to do it in a SUBform...
So is there an event I can attach to that will be called every time the
linked field changes? If so, would this be a good place to set
me.recordsource?
Maury
derived tables. However the performance is pretty poor, because it does a
select on everything in the view and then filters down after the fact.
The query would run much faster if I could write out the SQL and put the
filter right in the WHERE "by hand". In this case the query takes
milliseconds. I do this sort of thing all the time in forms, but I'm not sure
how to do it in a SUBform...
So is there an event I can attach to that will be called every time the
linked field changes? If so, would this be a good place to set
me.recordsource?
Maury