data display from a drop down

<i><b>Originally posted by : Julie (julie@hangtownwebdesign.com)</b></i><br /><br />I could sure use a little help here. I have a drop down menu that offers 6 choices that all works fine but when I tell it to display my info, I have a set criteria that I want displayed. For instance.......... I offer All Vehicles, Cars, Trucks, Vans, Sport Utility and Sport Cars in the drop down. You click on one and only those requested SHOULD show. Instead it gives all my cars in the data base. I have three tables made in the database. In the first table I fields that have the same fields Cars, trucks ect.... in each one I labeled all vehicles 1, cars 2, trucks 3 ect... what am I doing wrong?

<i><b>Originally posted by : steve</b></i><br />post your code<br /><br /><br />------------<br />Julie at 5/2/2002 11:35:34 AM<br /><br /><br />I could sure use a little help here. I have a drop down menu that offers 6 choices that all works fine but when I tell it to display my info, I have a set criteria that I want displayed. For instance.......... I offer All Vehicles, Cars, Trucks, Vans, Sport Utility and Sport Cars in the drop down. You click on one and only those requested SHOULD show. Instead it gives all my cars in the data base. I have three tables made in the database. In the first table I fields that have the same fields Cars, trucks ect.... in each one I labeled all vehicles 1, cars 2, trucks 3 ect... what am I doing wrong?