1. On the form (or report) with tab control you need to have a control that has the value of strFacilityID (i.e Text_FacilityID)
2. Then you need to Link master Fields = Text_FacilityID and Link Child Fields = TableName.FacilityID to the SubForm/Report on each tab.
3. On the Subform/Report you...