Access 2k and following seem to have gone out of their way to deny SQL ever existed, at least in the documentation. I will *always* write:
Set rstA = CurrentDb.OpenRecordset("SELECT * FROM tblALS_Add WHERE BatchNo = " + xxx, dbOpenDynaset)
...before I use the brain-dead query builder tools.
Can I assume your AHA! meant you tried something like:
sql = "SELECT * FROM tblALS_Add WHERE EXISTS (SELECT * FROM tblALS_V WHERE tblALS_V.BatchNo = tblALS_Add.BatchNo)"
Set rstA = CurrentDb.OpenRecordset(sql, dbOpenDynaset)
...or...
sql = "SELECT tblALS_Add.* FROM tblALS_V LEFT JOIN tblALS_Add ON tblALS_V.BatchNo = tblALS_Add.BatchNo"
Set rstA = CurrentDb.OpenRecordset(sql, dbOpenDynaset)
?