On Open Event Subform

[JohnLute]

I have two subforms:

sfrmPKProfilesAssocsFacIDs:
SELECT tblPKProfilesAssocsFacIDs.ProfilesAssocsFacIDsID,
tblPKProfilesAssocsFacIDs.ProfilesAssociationsID,
tblPKProfilesAssocsFacIDs.txtFacilityID, tblPKProfilesAssocsFacIDs.Comments
FROM tblPKProfilesAssocsFacIDs
ORDER BY tblPKProfilesAssocsFacIDs.txtFacilityID;

sfrmPKProfilesAssocsFacIDsLineIDs:
SELECT tblPKProfilesAssocsFacIDsLineIDs.ProfilesAssocsFacIDsID,
tblPKProfilesAssocsFacIDsLineIDs.LineID,
tblPKProfilesAssocsFacIDsLineIDs.Comments FROM
tblPKProfilesAssocsFacIDsLineIDs ORDER BY
tblPKProfilesAssocsFacIDsLineIDs.LineID;

sfrmPKProfilesAssocsFacIDsLineIDs.LineID is a combo box:
SELECT tblFacilitiesLineIDs.LineID, tblFacilitiesLineIDs.Description,
tblFacilitiesLineIDs.txtFacilityID, tblFacilities.FacilityName,
tblFacilities.City, tblFacilities.StateOrProvince
FROM tblFacilities INNER JOIN tblFacilitiesLineIDs ON
tblFacilities.txtFacilityID = tblFacilitiesLineIDs.txtFacilityID;

How can I have this combo box open and display the LineID records according
to the record selected in sfrmPKProfilesAssocsFacIDs.txtFacilityIDtxtFacility?

Thanks!