Hi guys, I am trying to show the number of records in my database...

how ever this is not working



Code:
Set rs = db.OpenRecordset("SELECT * FROM `Leads` WHERE `CurrentStatus` = " & "'" & opened & "' AND `Agent` = " & "'" & Combo1.Text & "'")
Label10.Caption = rs.RecordCount
rs.Close