Checking for common fields in two recordsets

[mflower]

Hi, anyone knows how I can check for common fields in two recordsets?
If rst1.ID = rst2.ID Then
MsgBox ""
Else
MsgBox "There are no matches"
End If

Why won't this code work?

 

[cmmrfrds]

I assume this code is after you have selected both recordsets.
If rst1.ID = rst2.ID Then
MsgBox ""
Else
MsgBox "There are no matches"
End If

Access properties, methods, objects, etc.. are referenced using the period.
rst1.EOF, rst1.RecordCount, rst1.MoveFirst

Variable names which are part of a select statement are referenced using the !
rst1!ID, rst2!ID, etc...

 

[mflower]

Thanks cmmrfds. Please tell me how to select the recordsets? I cant' seem to define the table in the form itself, keeps coming up with error for the table. Please help.

 

[cmmrfrds]

The table or select statement for a From goes in the recordsource property under the data tab for the Form.

 

[gol4]

looks to me like mflower might consider aggrate function like dcount() or sql

if dcount("id","rst2",rst1.id = rst2.id) then msgbox()

or

SELECT count(rst.id)
FROM rst1
INNER JOIN rst1 ON rst1.Iid = rst2.id;