Update data on form based on combo box changes

[So Call Me Crazy]

Hi.

I have a table that contains (among other items) a numeric field that
represents a state & county. Let's call it TBL_INFO. I have another table
that "translates" that numeric field to it's corresponding state and county.
Let's call it TBL_LOCALE. I have a form whose data source is a query that
joins the two tables so that the user sees a state and a county, rather than
a number. Let's call the query QRY_INFO.

I have some combo boxes that give the user the ability to change the state
and county.

I need an AfterUpdate event that will then run and get the new numeric
representation from TBL_LOCALE that equates to the changes the user made.
I've tried a couple of things but with no success.

TIA.

 

[KARL DEWEY]

Use the query QRY_INFO as source for a combo box that is bound to your field.