On Mon, 08 Dec 2008 15:44:59 GMT, "ngordon via AccessMonster.com" u48023@uwe
wrote:

Thanks, I don't think I phrased my whole question correctly and am not
expecting people to do something for free that I should be paying for. I was
actually wondering why I wasn't getting a response. What a newbie ;-(

Take 2 - So my need is for the best way to associate a state in the "ST"
field that will then allow the selection of on or more counties located in
that state in the "COUNTIES" field. I have the data in XLS files.

It *sounds* like you want to be able to first select a state, and then select
from the counties within that state; e.g. you might have Benton County,
Arkansas and Benton County, Oregon and want to be able to select the right
one.

What I'd recommend is having a table of states and counties. You can actually
get one on the web:
http://www.itl.nist.gov/fipspubs/co-codes/states.htm
Dig around on this site and you can download all the states and counties or
parishes with their unique FIPS code. This can be loaded into an Access table.
You can then base Combo Boxes on queries on this table.

You can base your County Combo box on a query referencing the State combo box
on the form as a criterion.

Hope this gets you started... if I'm misunderstanding the question please post
back!
--

John W. Vinson [MVP]