I downloaded your DB and I've done some conditional formatting in the subform you mentioned without an issue. Are you looking to format an entire record or just certain items within the record when you do your conditional formatting? Can you tell me which items in the sample database are supposed to be highlighted?
EDIT: After re-reading your post I agree with June, it appears you want to remove items from appearing in your POTENTIAL CUP FITS tab if they appear in your VERIFIED CUP FITS tab, if that's the case it's definitely an issue with your select query for the first tab. You currently have a cartesian query driving that subform but you can modify it just a little and get the results you want I believe.
First Make this Query:
Code:
SELECT [Lid Data].*, UniqueCupInfo.*
FROM [Lid Data], UniqueCupInfo;
Call it CupLidCartesian
Rename your existing QueryCupSearch to something else (so you have something to go back to if this fails to do what you want)
Create a new QueryCupSearch with this SQL code:
Code:
SELECT CupInput.CupEntryNum, CupInput.CupMan_ID, CupLidCartesian.Manufacturer, CupLidCartesian.[Lid Data].Cup_ID, CupLidCartesian.[Hot/Cold], CupLidCartesian.[Material&Type], CupLidCartesian.Volume, CupInput.Date_of_Arrival, CupInput.[Spec_Nominal-Rim_Diameter], CupInput.[Measure_Average-Rim_Diameter], CupLidCartesian.[Nominal-Seal_ID], CupLidCartesian.Lid_Item, Verified.IDFROM (CupLidCartesian LEFT JOIN CupInput ON CupLidCartesian.CupMan_ID = CupInput.CupMan_ID) LEFT JOIN Verified ON (CupLidCartesian.CupMan_ID = Verified.CupManID) AND (CupLidCartesian.Lid_Item = Verified.Lid_Item)
WHERE (((CupLidCartesian.[Hot/Cold]) Like IIf(IsNull([forms]![Search-LidGiven]![txtoptiontranslate]),"*","*" & [forms]![Search-LidGiven]![txtoptiontranslate] & "*")) AND ((CupInput.[Spec_Nominal-Rim_Diameter])>[Forms]![Search-lidGiven]![cup_search-min] And (CupInput.[Spec_Nominal-Rim_Diameter])<[Forms]![Search-lidGiven]![cup_search-max]) AND ((Verified.ID) Is Null)) OR (((CupLidCartesian.[Hot/Cold]) Like IIf(IsNull([forms]![Search-LidGiven]![txtoptiontranslate]),"*","*" & [forms]![Search-LidGiven]![txtoptiontranslate] & "*")) AND ((CupInput.[Measure_Average-Rim_Diameter])>[Forms]![Search-lidGiven]![cup_search-min] And (CupInput.[Measure_Average-Rim_Diameter])<[Forms]![Search-lidGiven]![cup_search-max]) AND ((Verified.ID) Is Null))
ORDER BY CupLidCartesian.Manufacturer, CupLidCartesian.[Lid Data].Cup_ID;
See if it does what you are looking for (anything that appears in the VERIFIED CUP FITS will not appear in the POTENTIAL CUP FITS