Im trying to check for a record during a double-click event but Im not sure my syntax is correct; would you please take a look. Any help would be greatly appreciated...
I would like to find the record, if it exists based on the parameters, and open it in the form.
I would like to find the record, if it exists based on the parameters, and open it in the form.
Code:
Set rs = CurrentDb.OpenRecordset("SELECT * FROM Employee Reviews")
rs.FindFirst ("EmployeeID=" & Me.EmployeeID & "AND Year = '" & "2021" & "AND Quarter = '" & "2nd Qrtr" & "'")
If Not rs.NoMatch Then
DoCmd.OpenForm "Quarterly-Review", acNormal
Else...