Dear experts -
I want to limit records in a record source to criteria in another field in a parent table.
Parent table = project_Parts. Key field: part_ID; other field I want to search on: part_number
Child table = Parts_revenue (includes field part_ID, but not field part_number).
I need to be able to dynamically change the recordsource to the subform showing the child table records, specifically limiting records to:
- Project_Parts_Revenue.Part_ID) In (SELECT Part_ID FROM Project_Parts WHERE Project_Parts.Project_ID=Forms!Project!txtProject_ID)
- but also project_parts.part_number falling into a named range (e.g.: in (1,4,5))