Filter vs SQL Statement

[Vensia]

Dear all,

To filter subform recordsource, is it better to use filter property or SQL
statement ?
Which one is fastest ?
Thanks.

Vensia

 

[Allen Browne]

Both work fine.

My personal preference is to apply a filter if I want the user to be able to
remove it using the interface they already know, and change the RecorcSource
if they should not be able to remove it (e.g. if the filter excludes
appointments of other users.)

The only catch is that Access doesn't work correctly if you filter both the
main form and the subform. Details:
Incorrect filtering of forms and reports
at:
http://allenbrowne.com/bug-02.html
(This bug is fixed in Access 2007.)

 

[Vensia]

Allen,

Thanks for the info.

Vensia

Both work fine.

My personal preference is to apply a filter if I want the user to be able to
remove it using the interface they already know, and change the RecorcSource
if they should not be able to remove it (e.g. if the filter excludes
appointments of other users.)

The only catch is that Access doesn't work correctly if you filter both the
main form and the subform. Details:
Incorrect filtering of forms and reports
at:
http://allenbrowne.com/bug-02.html
(This bug is fixed in Access 2007.)