I am working on a physical inventory database that uses a single table to hold all items to be inventoried. Each item is unique based on the inventory period and the location where it is physically counted. To enter the physical counts, each department has its own form filtered by department and sorted by location to match the counting sheets from the physical inventory. I'm stuck on how to filter the form with user input based solely on the inventory period date. I've researched how to pass the content from a combobox to form's filter property but I just don't understand how the code works. If that isn't the correct approach, how do I structure a query that would use a date from another table. I've attached a portion of the db for illustration. Thank you, any help would be greatly appreciated!