Here is the SQL code when I do it like you suggested...Not too sure how to read it
Code:
SELECT [Part Number].[Internal P/N], [Part Number].[Vendor P/N], [Part Number].ASSEMBLY, [Part Number].DESCRIPTION, [Part Number].MFG, [Part Number].[LM CODE], [Part Number].[LM RATIONALE], [Part Number].[REF DES], [Part Number].COMMENTS, [Part Number].DATASHEETS
FROM [Part Number]
WHERE ((([Part Number].[Internal P/N]) Like Forms!searchpn.QINTERNAL & "*") And (([Part Number].[Vendor P/N]) Like Forms!searchpn.QVENDOR & "*")) Or ((([Part Number].[Internal P/N]) Like Forms!searchpn.QVENDOR & "*") And (([Part Number].[Vendor P/N]) Like Forms!searchpn.QINTERNAL & "*") And ((Forms!searchpn.QINTERNAL) Is Null)) Or (((Forms!searchpn.QVENDOR) Is Null)) Or (((Forms!searchpn.QINTERNAL) Is Null) And ((Forms!searchpn.QVENDOR) Is Null))
ORDER BY [Part Number].ASSEMBLY;