Drop Down Boxes In Form Linked?

[GarageFlower]

I have a form ive created as part of my database used for data input.

Someone opens the form , enters their project number, and then enters what country it is in, what region it is in, and what sub region it is in. They are all dropdown menus with the information coming from a table via a lookup wizard.

What i want is when someone choses england in the country field, i want the region field to only displays the regions in england, and then in the sub region field i want only the sub regions that are in the regions displayed in the drop down list.

Anyone know how i can achieve this please?

I have attached a copy of the forms and tables

 

[ColinEssex]

This is called cascading ComboBoxes.

Look in the samples section on how its done, I think there's a sample Db in there

Col

 

[GarageFlower]

Dude i found this one

http://www.access-programmers.co.uk/forums/showthread.php?t=72424

The cascade feature on there is pretty much what i want

But im unsure on how to do all of this.. seems like it involves queries as well as id numbers on each table entry

Plus im not even sure which bits are coded

any more light you chould shed on the matter?

Cheers