Filter vs SQL Statement

V

Vensia

Dear all,

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

Vensia
 
A

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.)
 
V

Vensia

Allen,

Thanks for the info.

Vensia

Allen Browne said:
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.)
Click to expand...
 
Top