Dynamic Criteria in Access Query

Is there any way to set a dynamic criteria in Access 2010? Essentially I want to be able to set a "Status Date" and view results in numerous queries that occur before this status date. This is equivalent to a query with the criteria set to "<7/1/16" in design view. However, rather than going through every query and changing the date every time I want a different result set, I want to be able to change it once in a table or something and have it update automatically in all of my queries.

Using Access 2010.

Recent Questions...