Yes, you can tell MS Query that a cell value is a parameter. You can
also tell it to always use that range as the parameter for a query abd/
or to refresh the query if the value changes.

Cliff Edwards