I have created a data access page to display our items and prices etc.. by item number. I want to use a drop down box to select an item number and have the page goto the number selected. I have already read the MS AC 2002:285353 .
I'm having trouble implementing the code they give.
I'm able to set the drop-down box propeties fine, its the HTML script thats the issue.
Table contains:
Item
Price
Increment
drop-down box ID=Search,
list bound field=Item , from my table
list row source=table above
Script i'm using:
<SCRIPT language=vbscript event=onchange for=Search>
<!--
Dim rs
Set rs = MSODSC.DefaultRecordset
rs.Find "[Item] = '" & document.all.item("Search").value & "'", 0, 1, 1
'0 = Skip zero records before starting the search.
'1 = Search in a forward direction.
'1 = Always begin the search with the first record in the recordset.
-->
</SCRIPT>
I'm getting document doesnt support this method 'document.all.item'
I'm so close but just cant figure this one out.
Please help!
I'm having trouble implementing the code they give.
I'm able to set the drop-down box propeties fine, its the HTML script thats the issue.
Table contains:
Item
Price
Increment
drop-down box ID=Search,
list bound field=Item , from my table
list row source=table above
Script i'm using:
<SCRIPT language=vbscript event=onchange for=Search>
<!--
Dim rs
Set rs = MSODSC.DefaultRecordset
rs.Find "[Item] = '" & document.all.item("Search").value & "'", 0, 1, 1
'0 = Skip zero records before starting the search.
'1 = Search in a forward direction.
'1 = Always begin the search with the first record in the recordset.
-->
</SCRIPT>
I'm getting document doesnt support this method 'document.all.item'
I'm so close but just cant figure this one out.
Please help!
