1 Form with 2 inputs for 2 tables

I am wondering how I can go about this. I have 1 form with 2 inputs
that a user will fill in (i.e. State and County).

Here is what I am trying to do.

1) Once the user selects the State, the Country dropdown list would
auto populate the counties per the state. However, my ONChange
command doesn't work on the State dropdown. I need to pull the ID out
of the state table.

I've looked into macros which I don't believe would work. So I was
looking into coding the event but alas, I am not sure how to go about
this with SQL commands. I have been looking online for some examples
but nothing yet.

Thank you for helping me. I'm pulling out my hair.



Table State
----------------------
ID State
1 Florida
2 Texas

Table County
---------------------------
ID StateID County
1 2 pinellas
2 1 polk


Table User
-----------------------
ID User StateID Country ID
1 ted 1 2
2 sue 2 1