What do I need to do to get cascading combo boxes to work on a continuous form?

[TenOc]

Please excuse me if I do not describe the problem adequately. I'm a newbie.



I have cascading combo boxes on my form much the same as per the how-to video in the link below. Everything works fine when I view a single form. The problem is I want to view my form as a continuous form. When I change one records "state" it changes the "state" for all the records. What do I need to do to get cascading combo boxes to work on a continuous form?


https://www.youtube.com/watch?v=at0uaGSnUco

[ranman256]

yes, thats what continuous record form does....but since your combos are UNBOUND, you see the effect of all recs.
Dont put those combos on the detail line, put them in the HEADER.

only BOUND combos go on the individual detail line.

[CJ_London]

see this link
https://www.access-programmers.co.uk...s-form.275155/

[TenOc]

see this link
https://www.access-programmers.co.uk...s-form.275155/

Nice information, however, I have spent 3 hours trying to get it to work with my database. And I do not know how to ask for help. The demo dB works find, but I can not get the code to work with my db.

[June7]

Perhaps you should provide your db for analysis.

[TenOc]

I found the problem. A spelling error in my code.