Question about filtering in Data Access Page using a Command Button

[aviklund]

Hi,

I made a simple data access page with a search button that does work
properly, but now I would like to add a filtering to the command button
also.

Ideal solution would be like this:

When you press the command button it prompts you a search word (text
string) and then it filters the record set and shows all the records
that match for that search word. I also would like to use wildcards for
partial matches. Is this even possible with a command button?

I know that the "Filter by selection" button on the navigation bar does
basically the same thing, but the problem is I need to use partial
matches (and thus wildcards) because the record text strings are not
all similar even if they mean the same thing.

I would also like to know if it's possible to use command button as
hyperlinks?

Hopefully somebody can help.

- A.J.