Filter

[Guest]

hello,

I've created a form which I would like to use to look up information on the
field client_name so I can get a few of all files of that client

I've added a command button to my form and would like the action to take
place as I strike enter

I went to the eventprocedure and added this:

Private Sub cmdFilter_Click()
Me.Filter = "Client_name Like '*" & Me.txtFilterNaam.Value & "*' OR "
Me.FilterOn = True
End sub

it doesn't work the result I would like to have is by typing e.g. "royal*
or? " it returns Royal Belge, Royal Concern ect...

I also don't know how to turn my filter off as I only have one command button.

Please go easy on me and many thanks in advance!!

Halima

 

[[MVP] S.Clark]

Is your textbox really called Me.txtFilterNaam? Me.txtFilterName?

Should something be after the dangling OR in your where clause?