Change Recordsource of a Data Access Page?

[FancyPrairie]

How do I programmatically change the Recordsource of a Data Access page?

 

[fneily]

If none of these help, please be more specific in what you are doing.

Controls Are Not Automatically Rebound After You Change the RecordSource Property

http://www.kbalertz.com/kb_Q203179.aspx

How to Determine the Record Source of a Data Access Page

http://support.microsoft.com/kb/257733

Filtering code:
<SCRIPT language=vbscript event=onclick for=btnFind>
<!--
' Clone the recordset.
Dim rs
Set rs = MSODSC.DataPages(0).Recordset.Clone

On error resume next
' This line assumes that the value you are filtering on is an integer.
' If the search value is a string, use slightly different syntax.
rs.find "CustomerID = '" & CStr(InputBox("Please enter customer to find", "Find")) & "'"
rs.find "ProductID=" & cLng(inputbox("Enter a ProductID","Find"))

' Custom error handling.
If (err.number <> 0) Then
Msgbox "Error: " & err.number & " " & err.description,, _
"Invalid Search"
Exit Sub
End If

' Check search results for success.
If (rs.bof) or (rs.eof) Then
Msgbox "No Product found",,"Search Done"
Exit Sub
End If

MSODSC.DataPages(0).Recordset.Bookmark = rs.Bookmark
-->
</SCRIPT>

 

[FancyPrairie]

I appreciate your response, but that's not what I was looking for. Here's what I have.

I have a data access page (Employee.htm) whose Recordsource is based on a stored procedure. This page is loaded within an iframe within another page (Page1.htm)

I have created another page (Page2.htm) that loads the same page (Employee.htm) in an iframe. Consequently, when the page (Employee.htm) is loaded, I need to determine the name of the page that is hosting the iframe. If Page1.htm is hosting the iframe, then the RecordSource for Employee.htm needs to be one stored procedure. If Page2.htm is hosting the iframe, then the RecordSource for Employee.htm needs to be another stored procedure.

So, my question is, how do I change the RecordSource programmatically?

 

[fneily]

After reading:
Scripting the Data Source Control in Data Access Pages

http://msdn2.microsoft.com/en-us/library/aa139944(office.10).aspx

it seems you could use:
SetRootRecordset Method

http://msdn2.microsoft.com/en-us/library/aa193665(office.11).aspx

Since I have Access 2000 and SetRootRecordset is in 2002, I've never tried it. But the example they give looks like what you want.