Search Form Using Database

First off I would like to thank anyone that lends me a helping hand. I use to work a lot with VB but over the last 5 years I have forgot most of what I had learned. I am trying to make a search form for my web page to make it easier for my customers to find the correct product. Ill try to lay out what I am trying to do the best I can.


Access database

Car Make Car Model Year Engine Size Conversion Kit

Ford Thunderbird 1988 302 EFI 8VAB-EV1
Ford Mustang 1988 302 EFI 8VAB-EV1

and so on for all makes models and years


I would like for my future customers to be able to click on a drop down box for make, model, year and engine size and with the click of a search button have the form send them to the web page connected to the conversion kit. I have been talking with many people and I have not been able to get an answer on the best way or easiest way to make a this form. If anyone could help with some code or even some tutorials that I could read to get me going it would be highly appreciated.

Thanks again
Douglas J Cottrell II

Hi,

Welcome. As for the tutorials, I rather don't know how what you've been using/planning to use for to build your site PHP, ASP....? Search for the corresponding term on the net and you'll get plenty of hits.

In the help files (or on-line) you might also want to check
1) how to open an ADODB connection to the underlying database
2) how to open an ADODB recordset
(concatenating values from the dropdown boxes, etc might look like

select * from table1 where field1= '" & MyComboBox.Text & "'....


Also check a number of relevant links here
http://www.xtremevbtalk.com/showthread.php?t=39722

When you have more concrete questions, don't hesitate to come back.

Regards,
Shurik.

p.s. By the way putting Access database behind a web-application is not the best idea to say the least. I think you'll have to overweigh using another database.