Trying to Make a Search function for a SplitForm

[zashaikh]

Hello.

I have a SplitForm. I want to create a search function to search for certain records in the SplitForm. I believe this must be done using "ApplyFilter." But everytime I have tried, I am being told I incorrectly input my WHEREIS function. I want my search function to be a field linked to a command button. If I type in "Africa" in my search field, I want to get a return of all the records that reference Africa in my Split Form.

This is the basic thing I need help with. I will eventually be making this a little more complicated. But baby steps...

THanks!!!

[aytee111]

To set a filter on a form (it seems here that it would be in the OnClick event of the ApplyFilter button):
Me.Filter="fieldname='" & Me!textfieldname & "'"
Me.FilterOn=True
Me.Requery

Note - for text fields you need to include the single quotes, for number fields these would be omitted.

[zashaikh]

Thank you. I tried inputing the code so it looks like this:

Private Sub btnSearch_Click()
Me.Filter = "keyword='" & Me!Country & "'"
Me.FilterOn = True
Me.Requery
End Sub



However, it is still not working. When I try typing in a word, a popup box opens asking me to enter parameter value. If I type the word again, I am taken to a blank SplitForm.

[aytee111]

You show code from the button, but the error message is coming from the search field? Two different areas.

[zashaikh]

The image above if my main SplitForm. I typed in Nigeria in the "keyword" field. Then I pressed search.


I then am told to enter the parameter value (as seen in picture two.) So I type in Nigeria again, but then I am told to enter parameter value again and again and again.



Lastly, I am given a Microsoft Visual Basic Run Time Error 3021.


When I click "debug" I see this.

[aytee111]

The field "Keyword" is not being recognized by Access. This field must be somewhere on the form (it is not on any of your screen prints above). Should the field name be "Country" instead?

[zashaikh]

"Keyword" is the name of the field where I type in the word I want to filter. In the pictures above, I typed in "Nigeria" in the keyword field.

When I hit the command button, I want to return all incidents where Nigeria is identified as a "Country" (The field in between Region and Category)

[aytee111]

The code for the filter that I gave you in post #2 says - filter all records where the "fieldname" (on the table) is equal to the fieldname on the form. So the field name on the table is "Country" and the field name on the form (where you type in Nigeria) is ??? Keyword? If so, post #3 the fieldnames are reversed.

[zashaikh]

I tried updating the info in the code. I am not getting an error, but I am also not having my results filtered

[aytee111]

Do you know how to debug? If you put a stop in the code and then when you click the button hold the mouse over the "Me!Keyword" and see what value it has. Either that or add a line saying "Debug.Print Me!Keyword"

[zashaikh]

I am sorry. But I am not sure about how to debug or what to do at all

[aytee111]

Add a line of code to your button click - after Me.Filter=
add the line: Debug.Print Me!Keyword
Then click on the button
then go to VBA
At the bottom there should be a line - if not, go to View>Immediate Window
the value of the keyword will be shown there.

I am trying to make sure that there is a proper value in the filter field

[zashaikh]

I attached the picture
And btw, I really really appreciate this help

[Missinglinq]

Presumably Keyword is an Unbound Control on the Form...try replacing the Bang in "Me!Keyword" with a Dot "Me.Keyword"

Linq ;0)>

[zashaikh]

I replaced Debug.Print Me!Keyword with Debug.Print Me.Keyword


Now in the "Immediate" Window, it just says "Null"