filter subform by records dont exist in query

[civl_eng]

hi all, i have a query and a table2, and i created subform from table2, now i want to filter subform based on records that don't exist in query (query1) from same id in tow object. is it possible to do?

My querry1 from table 1 :





table2 :



Subform of Table2 based on query1 :

[CJ_London]

use a left join to join your table to your query and filter out the records which have a match - something like

SELECT Table1.*
FROM Table1 LEFT JOIN Query1 ON Table1.K1=Query1.K1
WHERE Query1.K1 IS NULL

[civl_eng]

hey,,thank you for reply,,,but it doesn't work for me..and i get this error :




i type this code for sql :

Dim pSQL As String


pSQL = "SELECT Table1 * FROM Table1 LEFT JOIN Query1 ON Table2.K1=Query1.K1 WHERE Query1.K1 Is Null "


Me.Table2_Sub.Form.RecordSource = pSQL
Me.Table2_Sub.Requery

[CJ_London]

you are missing a .

SELECT Table1 *

also there is no Table2 - ON Table2.K1=Query1.K1

You are mixing up the code I provided with the tables and query you originally provided

Always better to give tables/fields meaningful names