There's a textbox TxtFind and a subform in datasheet view SFListing.
When the user enters text in the textbox, the datasheet automatically
filters its list. I'm using this code to filter it:
Form.RecordSource = strSQL

Should I simply use the Filter property of the subform in this case? Which
one is more performant?

It's really your choice.

One possibility is to use the form's Filter when you intend for the user to
be able to remove the filter (e.g. when filtering to one category), but
change the form's RecordSource when the user should not remove the filter
(e.g. when viewing messages/appointments specific to this user).

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Michael" <(E-Mail Removed)> wrote in message
news:%(E-Mail Removed)...
> There's a textbox TxtFind and a subform in datasheet view SFListing.
> When the user enters text in the textbox, the datasheet automatically
> filters its list. I'm using this code to filter it:
> Form.RecordSource = strSQL
>
> Should I simply use the Filter property of the subform in this case? Which
> one is more performant?