Use a text box & command button to search entire table

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • Tim Mullin
    New Member
    • Aug 2010
    • 48

    Use a text box & command button to search entire table

    Hi all,

    This is a request that seems pretty common, but I have yet to find a definitive answer for it. I'm also fairly new to Access/VBA, so my apologies if this seems redundant.

    I would like to create a simple text box on a form accompanied by a button that runs a command/query/macro that will search an entire table for a keyword that a user types into the text box.

    I have tried queries using the "Like" operator with no avail, perhaps someone can assist me.

    Form Name: QueryScreen
    Table name: Clients
    Text Box name: Text62
    Button Name: Command64
Working...