You posted Test database is deficient, in that combo box "Value" does not have a recordsource property.
Your control names are deficient. Google "Hungarian naming convention" for a good way of naming Access controls. I use the control name to indicate the data type of the control which alleviates confusion over control data types.
The ControlType is completely irrelevant when writing SQL.The "Hungarian naming convention will save worlds of grief, 2 years from now when your program is modified, most particularly in building sql queries when controls have very generic names and one cannot test the data type of the control and what tyre of control it is.