Hello! Happy Thanksgiving everyone!
I keep getting a syntax error with this:
Code:
Private Sub Combo138_AfterUpdate()
On Error GoTo Combo138_AfterUpdate_Err
Debug.Print Combo138.Column(2)
Debug.Print Combo138.Column(3)
DoCmd.SearchForRecord , "", acFirst, " [memberid] = " & Combo138.Column(2) And "[PrimaryLotNum] = " & "'" & Combo138.Column(3) & "'"
'"[PrimaryLotNum] = " & "'" & Screen.ActiveControl & "'"
'WHERE ([AccountName]='" & Me.cboAccount & "'"
Combo138_AfterUpdate_Exit:
Exit Sub
Combo138_AfterUpdate_Err:
MsgBox Err.Description, vbCritical
Resume Combo138_AfterUpdate_Exit ERROR HIGHLIGHTS HERE
End Sub
The memberid is a number and the lot number is text. I'm using a combo box to find the member and their respective lot number (some members have more than one lot and assessment). My debugs print the correct information. I know my issue is with the quotes. TIA!