Code:
Private Sub FindCPU_MouseUp(Button As Integer, Shift As Integer, X As Single, Y As Single)
Dim strSearchStr As String
' Clear Location Text Box.
Me!Search_Location.SetFocus
Me!Search_Location.Text = ""
Me!Search_CPU.SetFocus
' Build the SQL query.
strSearchStr = "SELECT CPUs.* FROM CPUs WHERE Name LIKE '" _
& Me!Search_CPU.Text & "'"
' Set the query.
Me.RecordSource = strSearchStr
End Sub
With the code above, how can I determine the result of an SQL query? More importantly, how can I determine if zero records were found?
Thanks in advance.