Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
SubForm Navigation
- Thread starter Jagstrom
- Start date
You would need something on the lines of:
Code:
Dim rs As DAO.Recordset
strSQL="Select ID From MainTableName " _
& "Left Join SubTableName " _
& "On MainTableName.JoinFieldName=SubTableName.JoinFieldName " _
& "WHERE SubTableName.JoinFieldName Is Null"
Set rs=CurrentDB.OpenRecordset(strSQL)
Me.Recordset.FindFirst "ID=" & rs!ID- Status
Similar threads
- Locked
- Question
