Clarification of solution for cascading combo box on continuous subform

[halnurse]

I am having an issue with getting my cascading combo box to work on a subform with a continuous forms format. If I understand correctly many people seem to have this issue as well and there isn't really a perfect solution. Just to clarify - when I select a material type from a cbo called Material_Type I want the combo box called Item_Description to only show material of that type. When I move on to the next record and choose a new material type the previous record for Item_Description goes blank but is properly saved in the table. I have found a potential solution in this link: https://www.experts-exchange.com/art...atasheets.html , specifically under the topic "General Solution".



I did try to copy and paste the first part of code into my database (changing the names of things of course) however I get an error with the first line of code that says "Compile error: Expected: end of statement". So I didn't get very far. I don't have much experience with code so if someone could explain how to execute this solution I would be super greatful!!

[CJ_London]

there is an example here

https://www.access-programmers.co.uk...ight=cascading