Combo Boxes

[Tim38]

Hi,
I am relatively new to using Access, but have made some simpl
databases so forgive me if I am asking an obvious question. Here's wha
I want to do!
My database is basically a Car Part Lookup database, so the use
selects the Car Make, Model and Engine Type from drop down menus an
then the relative parts for the car are displayed. My problem is wit
the Combo boxes. I want three Combo boxes to work as follows...
The first box selects the make. On selecting the Make, the second bo
displays the corresponding Models to that Make. Once a Model i
selected the third box displays the different engine types.
e.g. There are two makes in the database, Ford and BMW.
The Make and models being:
Ford Fiesta 1.1
Ford Fiesta 1.25 Zetec
Ford Mondeo 1.8
Ford Mondeo 2.0
Fors Mondeo 2.5
Ford Focus 1.6
Ford Focus 1.8
BMW 3 series E30 2.5
BMW 5 series E36 2.5

So say i wanted to select Ford Fiesta 1.25 Zetec, I want to select For
from the 1st drop down, have Fiesta,Mondeo and Focus displayed in th
second and select Fiesta and then have 1.1,1.25 Zetec displayed in th
third so i can select 1.25 Zetec.

I hope I have explained well enough. I'd appreciate any help

Regards,
Ti