Automate a filter button on a form

R

Rod ElEd

I would like a command button on a form that will ask which field to search
and what word(s) to search for. These are memo fields with info on books. I
have scanned posts in this group and discovered the following string that
seems to accomplish part of this task:
Like "*" & [What word?] & "*"
I would like to make this very simple for users; they cli ck the button,
answer the prompt questions, hit "enter" and the search executes.
What else do I need in the command?
Where do I put the code after I create the button?
Thanks in advance for any help.
Rod
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top