Hi there, I have a form based on a table of contractors and a subform based on the child table that lists the shifts for each contractor. I have a field called "week number" in the shift table and I want to be able to ask the user the week number when they open the form and have it filter out the shifts for just that week number. Can anyone help? Dawn