Search Form Using Database

[djcottrell]

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
E85andyou.com

[debasisdas]

1.You need to fill the dropdown from database
2.capture the value from user selection
3.pass the value to database and search using SQl statmnet.
4.If that returns tha value display on the form useing grid or any other control.