The not existent records

[Guest]

Hi all,

I have to forms cs1 and cs2 ,both of them contain almost the same records
, i want to open cs1 to view only the records that are not existent in cs2.
Could you help

 

[Guest]

Forms do not 'contain' records. Forms display records.

If you are using queries as records source for the forms then you can left
join them and use NULL as criteria for the cs2 data field.

 

[John Vinson]

Hi all,

I have to forms cs1 and cs2 ,both of them contain almost the same records

No. You have two TABLES which contain almost the same records. You
have forms which *display* the records in those tables.

, i want to open cs1 to view only the records that are not existent in cs2.
Could you help

Create a new Query, using the "Unmatched Query Wizard", using your two
tables.

John W. Vinson[MVP]