Bypass parameter value message on Button Filter

[JO505]

I have a button to filter a form and it works fine but I would like to not have the message window alert me every time I run it.

How can I just find all values "F" when the code is run?

Please Login or Register  to view this content.

Jim O

[gmr4evr1]

Have you tried adding Application.DisplayAlerts like so...

Please Login or Register  to view this content.

[JO505]

I get an Error Msg. Method or data member not found.

Jim O

[gmr4evr1]

My mistake, I didn't realize you were asking about this for Access....I thought it was for excel. I'm not sure how to do it for Access.

[aminao]

Hi, I am having the same error, and I have tried to remove the space over and over, but Access adds it by back when I click Ok to the zoom window to close it an save the field. Do you have any idea why I can't remove definitely that space?

[dominicb]

Good morning aminao

Unfortunately your post does not comply with Rule 4 of our Forum RULES. Do not post a question in the thread of another member -- start your own thread.

If you feel an existing thread is particularly relevant to your need, provide a link to the other thread in your new thread.

Old threads are often only monitored by the original participants. New threads not only open you up to all possible participants again, they typically get faster response, too.

[Arkadi]

@JO505,

See if this works for you:

Please Login or Register  to view this content.

Lol just realized the age of the original post... my bad.