M
missamay
I have cmbState and cmbCounty on a form that corresponds to a table. I
want the Counties shown in the cmbCounty to be limited by the State
chosen in cmbState. I have tried the code from the Access sample forms
and The Access Web with no success. I am pulling data from one table
and a query for the combo boxes. qryState contains a list of the 50
states and tblCounty has all the counties in the US with the
corresponding state. I am able to display the States in the combo box
by using the query as the RecordSource, but am unable to get the
Counties to display based on the state. I did not get errors when I
tried the code from the Access sample forms and The Access Web, but the
cmbCounty box remained empty.
Any help or suggestions would be greatly appreciated. Thanks!
Melissa
want the Counties shown in the cmbCounty to be limited by the State
chosen in cmbState. I have tried the code from the Access sample forms
and The Access Web with no success. I am pulling data from one table
and a query for the combo boxes. qryState contains a list of the 50
states and tblCounty has all the counties in the US with the
corresponding state. I am able to display the States in the combo box
by using the query as the RecordSource, but am unable to get the
Counties to display based on the state. I did not get errors when I
tried the code from the Access sample forms and The Access Web, but the
cmbCounty box remained empty.
Any help or suggestions would be greatly appreciated. Thanks!
Melissa