Is there a way to disable a query field (Not only hide it), so when I run the query and see the datasheet view, it doesn't take charge of that field and doesn't display it. I would like to be able to trigger (Enable/disable) some fields with a button or a check box maybe? Is it possible?
Example:
Picture 1 : The "Production Center" field is enabled
Picture 2 : The "Production Center" field is disabled (I just removed it from the query)