Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Filter records in sub form based on user input

Status
Not open for further replies.

dawnd3

Instructor
Jul 1, 2001
1,153
US
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
 
Am I just making this harder than it has to be? Can I just create a parameter query and use it as my record source for the subform?
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top