Should I re-create criteria using form filter of just use the relevant query as recordsource?

  • Thread starter Thread starter Chris K
  • Start date Start date
C

Chris K

I need to create a range of (5 or 6) filters for a form and let the user
choose them from combo - also need to create some reports/mail merges using
same criteria but via query

If I already have some queries with correct criteria, should I re-create
same criteria using form filter of just use the relevant query as
recordsource?

Which would best approach?
 
Chris K said:
I need to create a range of (5 or 6) filters for a form and let the user
choose them from combo - also need to create some reports/mail merges using
same criteria but via query

If I already have some queries with correct criteria, should I re-create
same criteria using form filter of just use the relevant query as
recordsource?

Which would best approach?
Click to expand...

Specifying the name of a stored query as the form's recordsource will always
be the most efficient way. Stored queries optimize themselves as they are
run against data. Such optimizations are retained for future sessions. This
way your form can take advantage of them.
 
Stuart McCall said:
Specifying the name of a stored query as the form's recordsource will
always be the most efficient way. Stored queries optimize themselves as
they are run against data. Such optimizations are retained for future
sessions. This way your form can take advantage of them.
Click to expand...

Yes I think I'll use the queries as record source
 
Back
Top