Data Access Pages: manipulate objects in window 2 from script in window 1.

I'm trying to construct an on-line request processing system using Access 2000 Data Access Pages. I want to open a new window, using window.open, and write a value to a textbox on the new window, from script in the original window.

I've been trying to adapt some code from a MS Technical document. It looks like this:

Dim newWin
Set newWin=window.open("FileName",null,"center:yes")

So far so good. That works. The new page opens. Then I hit problems. The sample code I'm copying is designed to set the sort order of the data set. It reads as follows:

Dim myDSC
Set myDCS=newWin.document.all.MSODSC
myDSC.defaultRecordset.sort="ShipDate"

However, I dont want to sort the recordset, I want to put a value into a textbox called txtDiscountNumber which is on the new document. How the hell do I address the text objext to write to its .value property? I've been trying different variations for days now and I'm loosing the will to live.

Please, can anyone help?

here is one idea, i did something similar to this.
have a dynamic hidden form variable created in your loop to output your record. then have a function that opens the new window with a few paramaters like the ID of the specific item you want to load in the new window. then you can use the window.opener.document.formname.hiddenvariablename.value and put that in a text box or something. let me know if this helps or if you need more info.

Hi Don.

Thanks for your response.

I think I understand where you're coming from but I don't believe it's what I'm looking for.

What I have is a Data Access Page attached to one Access table. The page is going to be used to enter a request for work from another department. That record, when created, picks up a request number ( an AutoNumber field). When the details are completed, I want the user to open a second Data Access Page. I want to write the request number to the second Data Access Page , which is attached to another Access table, and use the common number from both windows to connect the records in each table.

Can that be achieved with what you suggest?