Help with cascading combo boxes

[so_lucas]

Hi all,

I've spent quite a lot of time searching for an answer to this problem but I haven't had any luck finding an answer. I'll try to give as much information as I can but if you need more then please ask.

I have 3 cascading combo boxes that work like this (names are changed):
State,
City,
Street.

Obviously, depending on your choice to the first box will result in certain options for the second and third.

The data for the combo box options are held in separate tables while the control populates a master table for each 'customer.'

The combo boxes work fine as they are, my problem is that when I re-open the form only the first record displays the choices I've previously made for the combo boxes. When I navigate through each record the City and State boxes remain blank unless I click on them.

Any ideas how to resolve this issue?

---UPDATE 30/11/12 ----

I resolved this issue by creating an event on the form under 'current' which re queried the combo boxes so that every time I navigated to a new record it re-queried them

 

[YNWA]

Are you using continuous forms?

 

[so_lucas]

No it's not a continuous form, it was part of a subform however. After reading some threads which seemed to suggest subforms can cause problems for cascading combo boxes I tried using the form by itself but still to no avail.