HAVE TRIED BUT CAN'T SEEM TO GET IT RIGHT

[Guest]

I think what you want to do on the After update of the
PrspDemoState field you will want to do the following
Me![PrspDemoCounty] = null
Me![PrspDemoState].requery

You set it to null since if you are choosing another
state, the county will no longer be correct. Then you
requery it to refresh the data.

The rowsource should be assigned to the PrspDemoCounty
and will not have to be reassigned using code. It should
be something like the following:

Select [CntyDesc] from tbl_counties Where
[CntyState] = Forms![YourFormName]![PrspDemoState]

(this uses the full name for the PrspDemoState)

I hope that this helps.

Sue