Access 2002: Any experiences with conditional combo boxes?

I am trying to make a combo box which is based on the response to the previous combo box. By selecting a value in combo box 1, you will change the contents in combo box 2.

Example:
Combo Box 1 = {California, Utah, Nevada, Arizona}
YOU SELECT 'ARIZONA'
Combo Box 2 = {Phoenix, Flagstaff, Yuma}

I have seen a visual basic program in the Microsoft Access 2002 text book but it would not work when I tried it.

Thanks for the help

You just need to change the RecordSource property of the combo box.

Have you got some sample code you can post?