Continuous Form problem->Please help

[djc]

OK here is the problem...I have two combo boxes in a continuous form. One is pre-populated at run-time and it contains all the states in the US. The second populates the counties from which state you select. It works when you select a state and then the counties are populated and you can add more states and counties. But when you go back to change the county for a previously entered state, the county combo has the values of the last entered state. I need to find a control that treats each record independently. I would also like to use this as a datasheet also. Thank You in advance.

 

[jadeIT]

what do you mean by

"But when you go back to change the county for a previously entered state, the county combo has the values of the last entered state"?

How are you going back to the previously entered state? Via the naviagtion buttons at the bottom of the form?

Have you entered any code in the forms on_current event?

You might want to put this

cboCountyCombo.requery

where 'cboCountyCombo' is the name you have given the county combo control.

or even put it in the get_focus event of the control itself.