Hi Leigh.
The best idea is going to be to combine them all into one table, with a
State field to indicate which state the record is for.
It is then every easy to create a query to pull the records for just one
state. You can even create a different form for each if you like (based on
the query).
But when you want to query the data across states, it will be *much* easier
than trying to work with a large, unweildy, read-only UNION query.