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 lena_basiti[ at ]landsafe.com, do not have access to email listed
to this account at work!! Thank you!!
|
|