Help with displaying results in a form based on a Combo box select

L

Lena

I am trying to create a form in Access 2003 and am having issues. Here is
what I am trying to do. When I select a field in the Combo box I want the
results of a query to be displayed on the same form. (I am working on a state
license database)
In the form I have a Combo Box that has the name of each state (combo box's
row source type is Table/Query, row source States). I have built a query for
each state that displays the nameS of the people licensed in that state,
license number, and contact info for each person. Is there a way when I
click on the state located in the combo box that a subform(?) display the
results of the query for that paticular state? How do I get different
queries to run by choosing a different state in the combo box.

Please email (e-mail address removed), do not have access to email listed
to this account at work!! Thank you!!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Clearing combo boxes and a text box 2
Creating a Search using a combo box and then creating a report. 4
Trying to remove error from conflicting code 0
Dynamic Naming of Form Button 3
Link a text box based on drop down box with four options MS Word 365 0
Combo box 0
List box loads slowly first time but quicker on subsequent requerying 0
Combo or list box 0

Top