run-time error 438 1

[neronikita]

Good morning,

I am getting a run-time error '438' Object doesn't support this property or method when I click on my button.

Here is my code:


Private Sub searchname_Click()
Me.Filter = "[customername] LIKE " & Me.searchname
Me.FilterOn = True
Me.Requery

End Sub

customername is the database field name, and searchname is the unbound text field where they enter the criteria.

I've been researching this and have tried everything I could think of, so I thought maybe a fresh pair of eyes would help. I am using SQL Server 2008 and Access 2007 in an access data project.

Thanks in advance,

Di

 

[randy700]

Perhaps

Me.Filter = "[customername] LIKE [b][red]'[/red][/b]" & Me.searchname [b][red]& "'"[/red][/b]

Randy

 

[neronikita]

Thanks. It has been ages since I've worked with Access (since 2000) and everything seems so different. Guess I'm a little rusty. That worked.

Thanks again,

Di