MS Access Programming ComboBoxes

[mcsacks]

Hi,

I am trying to program in Microsoft Access 2003

What I would like to do is the following:
I have 2 combo boxes, BranchID and DivisionID and they are on form Custodian.

What I would like to happen is that when a user makes a selection in the BranchID ComboBox that the field in the Division ID is automatically updated to the correct data.

ie)
If you select "Mapping" in BranchID ComboBox then the DivisionID combobox will change to "Land and Water"
And if you select "Spatial" in BranchID ComboBox then the DivisionID will change to "Natural Resources"

And so on....


Thanks