.Find help

[vz]

I have a find statement that takes whats in a text box and searches a recordset for it but its not working can anyone tell me why?

Dim tempAcctNum As String
tempAcctNum = txtAccountNum
adotblaccounts.Recordset.Find "AccountNum=tempAcctNum"

this blows up and says its out of acceptable range, AccountNum is the name of my field which is of type text.

But if i put this in, it works:
adotblaccounts.Recordset.Find "AccountNum=123123"

Am I doing something wrong?
Thanks

 

[vz]

Nevermind i figured it out:

adotblaccounts.Recordset.Find "AccountNum='" & tempAcctNum & "'"

thanks anyway