Synchronize Two Combo Boxes on a Form

I am a newbie to Access and am currently using Access 2007 and need help with
synchronizing two combo boxes on a form.
I have read through many of previous discussions and some of the suggested
links but none have seemed to help so far.

I have 2 tables one with Regions and one with States.
I would like to to create a combo box on a form, so that when I choose a
region it will automatically fill in the region's state.

On Mon, 26 Oct 2009 21:44:03 -0700, Combo_novice
wrote:

I have 2 tables one with Regions and one with States.
I would like to to create a combo box on a form, so that when I choose a
region it will automatically fill in the region's state.

Base the Region combo box (cboRegion I'll call it) on a Query like

SELECT Regions.RegionName FROM Regions ORDER BY RegionName;

adapting the fieldnames appropriately of course.

Base the States combo on a query like

SELECT States.StateName FROM States WHERE
States.Region=Forms!YourFormName!cboRegion
ORDER BY StateName;

adapted again as needed...

Put a Macro in the AfterUpdate event of cboRegion to Requery the States combo.
--

John W. Vinson [MVP]