Filter or RecordSource

  • Thread starter Thread starter Michael
  • Start date Start date
M

Michael

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).
 
Back
Top