Runtime Error '3077'

[isaace]

I am trying to create a pop up list of all leads from a main form. upon selecting the record i would like to find, I receive a runtime error 3077 message; Syntax error in date in expression. can anyone help?!

Private Sub cmdShowActiveLeads_Click()

Dim rs As DAO.Recordset
Set rs = Forms!frmLeadMain1.RecordsetClone

Call rs.FindFirst("Lead# =" & Me.Ctl1stLead.Value)
Forms!frmLeadMain1.Recordset.Bookmark = rs.Bookmark
Call DoCmd.Close(acForm, "frmFindActiveLead")


End Sub

[Rabbit]

Use [Lead#]. The pound sign is a reserved character to designate dates.

[isaace]

Ahhh....it worked!!! Thank you!!