Search box in Data Access Page

[Michael Auer]

Hello, all.

I am new to this forum and am impressed with the knowledge and support offered here.
I have just added a search drop-down to my DAP and added the necessary code to allow me to click on a name in the drop-down to show that record. It works great in finding the records except that the names in the drop-down are not in alphabetical order as I believe the code indicates they should be.

Here is the code:

<SCRIPT LANGUAGE=vbscript FOR=CustID EVENT=onchange>
<!--
Dim rs
Set rs = MSODSC.DefaultRecordset
rs.Find "[CustomerID] = '" & document.all.item("CustID").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>

...as copied from Microsoft's website. Of course, I changed the code to reflect the names of the fields in my DB.

Any help would be greatly appreciated.

Mike

 

[cyr0n_k0r]

how did you manage to do this? I am trying to add a box that contains a list of software names from a table and when you click on the name it goes to that record.

Although Im hoping you have solved the problem of the alphabetical order thing.

 

[Michael Auer]

Here is the link to the Microsoft web page:

http://support.microsoft.com/default.aspx?scid=kb;en-us;285353

I have not solved the problem yet of the alphabetical order of the names in the drop-down. Please let me know how yours turns out.

Mike