Removing the Filter in a Search Form

[Mickster]

Hi there, I currently have a search subform that will search for a specific record based on an ID or Name. However I do not want all the records to be filtered. I still want the user to be able to traverse through the other records.

Is there any way that I can disable the filtering?

thanks

 

[Calvin]

Work SQL into your process instead of using filters. It's faster and more flexible than filters.

MyForm.RecordSource = "SELECT * FROM MyTable WHERE MyField1 = 'xyz' AND MyField2 = 'abc' ORDER BY MyField3, MyDateField"

If you don't know what SQL is or understand it's syntax, search this forum, it's full of good info. You can concatinate strings and textbox, comboboxes etc... to assemble an sql string, this can be especially helpfull weather you have a simple or complex Search process.