[Resolved]SQL Statement error

[dawgfather]

Hi

Im trying to search the database for the first name. and I get an error " Too few parameters. Expected 2". Could someone help me out. Maybe its very simple and ive gone mad looking at the statement for 5 hrs. Thanks in advance.

sqlsearch = "SELECT Contact.FirstName, Contact.LastName From Contact WHERE (((Contact.FirstName) Like '" & frmMain.txtSearch & "*')) ORDER BY Contact.FirstName, Contact.LastName;"
 
Set db = OpenDatabase("P:\Contact.mdb")
Set rs = db.OpenRecordset(sqlsearch)