Data Access Pages

[Linguist]

I have created a DAP and am trying to add some ActiveX controls to it.

I want to be able to prompt the user for word or several words and then have the DAP retrieve all the records that contain the word(s) and display them (the records) as a new RecordSet.

Here is the code that I have so far:

<SCRIPT event=onclick for=Command0 language=vbscript>
<!--
Dim rs
Dim strSearch
Set rs = MSODSC.DataPages(0).Recordset.Clone

strSearch = inputbox(&quot;Please enter a Locality: &quot
MSODSC.DataPages(0).Filter = &quot;Locality= '&quot; & strSearch & &quot;'&quot;
MSODSC.DataPages(0).Filter = adFilterNone
-->
</SCRIPT>

I want to use either the Filter property or an SQL query. How do I code either one in VBScript?

Any and all suggestions would be appreciated.
Thanks

 

[jonscott8]

Try

MSODSC.DataPages(0).Recordset.Filter = &quot;Locality= '&quot; & strSearch & &quot;'&quot;

Although, I'm not sure if that will make the page refresh/reload. Jon Hawkins