Dynamic combo box with results filtering - sample - help

[fotodj]

I need to redo attached sample database to be able to select in form first value ( Make) to show only (Model) values for that Make.


I know that requery has to be used as well but I am just a beginner and I can not get this working so far... (Access 2010)

Any help appreciated, thanks
Derek

[RuralGuy]

Is this what you had in mind?

[fotodj]

Thanks RuralGuy! That is exactly what I needed, now I can study your example and learn proper coding.

[RuralGuy]

You're welcome. Glad we could help. Just for the record, there are several way to achieve this result. This is only one of them.