Dim Rst As DAO.Recordset, strCrit As String
Set Rst = CurrentDb.OpenRecordset("CustItemList", dbopentable)
strCrit = "Custno = '" & Me.custno & "'"
If Nz(Me.item, " ") > " " Then
strCrit = strCrit + " And Item = '" & Me.item & "'"
If Not .NoMatch Then
. . .
The bolded, underlined line bombs. I get an error message: Run-time error '3251' Operation is not supported for this type of object.
.FindFirst doesn't work on a DAO recordset opened as a dbOpenTable!? Since when???? I also noticed something else that's strange. Why didn't VBA capitalize the O and T in dbOpenTable? Usually that's a hint that something's wrong. But what?
CustItemList is a stand-alone table, not a link.
I'm using A 02.
ps. Printing out strCrit in the Immediate screen gives me
Custno = 'TMCA15' And Item = '2145'
which is both what I want and syntactically correct for SQL.