Querying a Access Database

[jmurrayhead]

I have an access database that I want to create a query form for. I'm not sure how to do it. I want it to have default values in it based on session variables that I have set.
For example, First Name: <textbox value="<%=Session(appName&"x_firstname")%>"></textbox> Last Name: <textbox value="<%=Session(appName&"x_lastname")%>"></textbox>
Then they click the submit button and it retreives all records with the first and last name present.

All help is appreciated. Thanks

 

[jmurrayhead]

Yeah, the set objRS = oConn.execute(strSQL) doesn't seem to be working...I removed it and all errors were gone, the query still didn't work. I ended up using FrontPage to create my database and I created a query using the query wizard. The user still has to enter input, but at least it gives me something to work with until I can figure out a way to query automatically from their login session.

Thanks for your help.