Selection in form writes to correct query

[GregSmith]

Not sure if this is the correct question:

I have a form that has a drop down list.
When I select an item from the list, I want
it to fill in the information on the correct query
name.

Ex: I select TENNESSEE and it should right the
information that I put into the form in the
query called TENNESSEE

 

[cogent1]

What Info??

OK. But what is the information you want to write to the query? Is it a parameter? (something that tells the query which records it should display)

 

[David R]

It sounds like you have different queries for each state..

Is this really necessary? Can't you open one query and specify the State on the fly? Maybe I'm misunderstanding what you're trying to do...