I will see documentation about debug.print, but actually I always test my Private Subs by pressing on F5 key when I have my opended Form.
I have managed to make the dynamic search, here the solution (use of "LIKE" instead of the equal sign "="):
DCount(field_name, table_name, "[" & field_name...