Filter Form Help. - Microsoft Access Forum


	Back to Access Forum Comments List

Upload Images @Reply Bookmark Link Email Next Unseen

Filter Form Help.

Debbie Heaney

2 days ago

I'm trying to put together another project and I could do with a little help.
I'm fairly certain it's a double double quotes type thing? I just can't get the hang of those.
I'm trying to filter a form (Picture will follow shortly) based on what is entered into a text box, and I'm wanting to use the LIKE keyword to match partial words anywhere in the field.
I'm trying to test with a fixed/static value first before then moving to the textbox.

	Debbie Heaney OP @Reply 2 days ago

	Debbie Heaney OP @Reply 2 days ago
For testing I'm trying to get a partial match on "Battery". The value is fixed for testing but i can't get that to work. The form returns zero matches. As the screen shot stands the triple double quotes at the end were automatically added in by the autocomplete/correct. I did have it ending in single quotes.

Debbie Heaney OP @Reply

2 days ago

I had been working on this project for about 3 hours straight doing all sorts of things.
I put the laptop down, got up and walked away. Had a nibble on a bar of chocolate, a drink of juice, paced around the house like an idiot, threw some stuff around in temper.
It was a single versus double quotes thing.

I got it.

If Me.FilterOn = False Then
    Me.Filter = "Comments like '*" & txtFilterCommentsFor & "*'"
    Me.FilterOn = True
    btnToggleFilter.Caption = "Filtered"
Else
    Me.FilterOn = False
    btnToggleFilter.Caption = "Unfiltered"
    txtFilterCommentsFor = ""
End If

Now to take a good long break and eat a decent meal. the project can wait another day.

	Donald Blackwell @Reply 27 hours ago
Yeah, some times you stare at it so long you just have to give your eyes a break.

Next Unseen

New Feature: Comment Live View