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

[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?

 

[Stuart McCall]

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?

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.

 

[Chris K]

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.

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