Trying to Make a Search function for a SplitForm

[aytee111]

So, if it is null, then it is not picking up the value that is being entered on the form. Your names haven't been switched around like I specified in post #8.

[zashaikh]

I have tried it both ways. But I am still getting the Null error

[aytee111]

The last few show that it is picking up the country correctly. Are you getting the error on these or only on the null? Clear out the immediate window (select all and delete) so that none of the debug values are showing. Then enter the country and click on the button - what error are you getting now?

[zashaikh]

When I do this, I do not get an error. But nothing happens on my Form. My Form does not select any records that show Nigeria.

However, when I go back to the Immediate Window, "Nigeria" is listed

[aytee111]

I copied what you have here and it works for me. I notice that you are on 2016, I wonder if that makes a difference?

Also, in your filter statement you have Me! and in your debug you have Me. - I don't usually use the dot but I'm not sure if this makes any difference?

[aytee111]

Is your table design "clean"? What I mean by that is no formatting or lookups or naming manipulation or anything like that on the Country field of your table?

[zashaikh]

There is are no Lookups in the country field. And I dont beleive there is anything else.

This is a link of a recording of me trying to do a search

https://1drv.ms/v/s!Aqu9UKhK8oUTzg_limn3LzmuR6wn

[aytee111]

Yes, I see that it is all as it should be. I don't know how to help you further.

I recommend that you start a new thread, asking why your filter isn't working, leaving it in this one might take a while for someone else to notice it!

[zashaikh]

I understand.

That you so much for all of your help and effort. It means a lot.

Best of Luck

[aytee111]

Try this - change the filter line to: Me.Filter="Country Like '*" & Me!Keyword & "*'"

There may be some extraneous character somewhere, surrounding the Country with wildcard * will ignore those characters.

[ssanfu]

Here is a link to help you get started with debugging: http://www.cpearson.com/excel/debug.htm