I am a teacher at a school trying to make a Search "form" for pulling up athleates. I have all athletes in a Access Database, and have the connection to the database,. I havent got to the search par so that is one question i have, is this possible to do? ... Searching by last name, also How to I call the database into the correct fields? I have a table set up with a form. All text fields are named according to the database. Just do not know what code to use. Thanks in advance!


I am using Dreamweaver MX and MS Access

it's not as hard as it seems.

add a form to the page where you want to search from

textbox = fmSearch (or whatever u want to call it), point the form action to a results page like myResults.asp

add a go/submit button.

now on the myResults page, create a recordset and filter it by

lastname = Form Variable (fmSearch) - or whatever you've named the textbox on the previous page.

and drag what fields you want displaying for the record onto the page.

i think that's it, i haven't used this for a while it's off the top of my head.

regards

Dave Thomas
<b>DMX Zone Manager</b>