R
rodney24
Synchronized Combo Boxes in Subforms
I am using MS Access 2003 and have created a form using two combo boxes
where I select the state from the first combo box. The second combo box is
controlled by a query that looks at the first combo box so that when you
change the state name in the first combo box it requires and then lists the
available counties in the second combo box. This works very well but when I
place this form as a subform and link the master and child fields the form
finds several records which is right. But when I try to change the state
name on one of the records in the in the first combo box in the subform and
then pick the second combo box for the updated county list it does not find
the correct state and wants me to enter the parameter value.
I think that because I have it require the list of available counties that
it looses track of the record that I changed in the subform. Is there
something I can do so that works right in the subform?
I am using MS Access 2003 and have created a form using two combo boxes
where I select the state from the first combo box. The second combo box is
controlled by a query that looks at the first combo box so that when you
change the state name in the first combo box it requires and then lists the
available counties in the second combo box. This works very well but when I
place this form as a subform and link the master and child fields the form
finds several records which is right. But when I try to change the state
name on one of the records in the in the first combo box in the subform and
then pick the second combo box for the updated county list it does not find
the correct state and wants me to enter the parameter value.
I think that because I have it require the list of available counties that
it looses track of the record that I changed in the subform. Is there
something I can do so that works right in the subform?