Update data on form based on combo box changes

  • Thread starter Thread starter So Call Me Crazy
  • Start date Start date
S

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.
 
Back
Top