Modify msodsc.RecordsetDefs(0).ServerFilter to search for info in two fields

[cesemj via AccessMonster.com]

<SCRIPT language=vbscript event=BeforeInitialBind(info) for=MSODSC>

Dim pTextSearch
Dim errNot_Found

errNot_Found = "NOT_FOUND"

pTextSearch = ReadVariable("SearchFor...")

'Good
msodsc.RecordsetDefs(0).ServerFilter = "repair_summary like " & chr(34) & chr
(37) & pTextSearch & chr(37) & chr(34)
'msodsc.RecordsetDefs(0).ServerFilter = "repairNO like " & chr(34) & chr(37)
& pTextSearch & chr(37) & chr(34)

' Delete the cookie.
document.cookie = ""
</SCRIPT>