connecting combo boxes

[VOO Master]

I have a button on my switchboard that takes you to a form. The goal is to
make the form identify vessels working out of a particular port. I have set
up a combo box on the form which allows the user to select the Ocean or Sea
from the drop down. I want to set up another combo box with a drop down of
Countries. How do I make the available countries in the drop down only show
the countries associated with Ocean/Sea selected and not all available
countries. This would then be repeated for the Ports in Country and then Port
to Vessel. Maybe there is a better way to accomplish. Thanks for any help.

 

[SuzyQ]

If you have a table (tblCountry) with oceans / countries
I.E.

Ocean Country
Pacific US
Pacific Austraila
Pacific Canada
Atlantic Africa
Atlantic US
Atlantic England

etc.

In your countries combo box enter the query select country from tblCountry
where ocean = [Forms]![FormName]![OceanComboBoxName]

In the after update event of the ocean combo box enter code to requery the
countries combo box

me.countrycombo.requery