Access and the Web.

[bgfs]

I can create a query by form in access to take criteria from a form with drop menu and return all records that match. But how do you design an asp webpage that does the same? Anyone know of a good tutorial or have any pointers. Thanks

 

[fneily]

You could just create a DAP with a combobox in the Header and then place the following code on the onchange event. This will just show the records that matches the dropdown selection. But if you must use ASP, then I'm sure someone else will post an answer.

<SCRIPT language=vbscript event=onchange for=fname>
<!--
Dim rs
Set rs = MSODSC.DefaultRecordset

rs.Find "[NameFull] = '" & document.all.item("fname").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>

 

[dhookom]

This question might have a better chance of being answered in an ASP or similar forum. The first step in ASP would be to create a form with a <select> on it.

You can also search using Google to find tons of information.

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]