Controling Record of DAP

A

Airbonzo

Im posting this as a solution to a question I had previously asked
Say you have a DAP that has multiple levels of records such as a list of
items under a given PO. I had alot of trouble select which PO the page would
veiw without a server filter. The AbsolutePosition fails because the pagesize
of the page I was coming from was different than my PO page
First, I used a cookie from the page I was coming from to store the PO
number from a text box.
Then I compared the value of the cookie to the value of the purchase order
ID text box in my page and moved foward in the recordset until they were equal

<SCRIPT language=vbscript event=DataPageComplete(e) for=MSODSC>
<!--
dim test
test=Document.cookie
Do until test=PurchaseOrderID1.value
If (abs(test) > abs(PurchaseOrderID1.value)) then
MSODSC.CurrentSection.DataPage.Recordset.MoveNext
end IF
Loop-->
</SCRIPT>

Hope this helps
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top