finding record in recordset

[mik]

Hello,
Could you please help me with finding record in recordset?
When I use command

 rs.Find "Waluta = USD"

everytning works fine. When I try to use variable like this:

rs.Find "Waluta = " & kurs

no data is find.

Sub FindKurs()
Dim rs As ADODB.Recordset
Dim kurs As String
Set rs = New ADODB.Recordset
kurs = "USD"
rs.ActiveConnection = CurrentProject.Connection
rs.Source = "tbl_kursywalut"
rs.CursorType = adOpenDynamic
rs.LockType = adLockOptimistic
rs.Open
rs.MoveFirst
rs.Find "Waluta = " & kurs
MsgBox rs![kurs]
End Sub

Thanks,

[ranman256]

Instead of find, would you rather just just build the where in a query...

set rs = currentdb.openrecordset("select * from tbl_kursywalut where " & "[Waluta] = " & kurs