Results 1 to 2 of 2
  1. #1
    Join Date
    Feb 2004
    Posts
    67

    Question Unanswered: Help with Client List?

    I have a DB of clients. I would like to setup a form "LocateClients", enter their last name and have a subform list the clients matching the entered last name. I have the FORM working, as long as I enter the correct lastname. I would like to enter as little as the first letter and have all records list. I have tried to use the (Like "*") wildcard but am having trouble. Does anyone have a good suggestion?
    Thanks...Chuck

  2. #2
    Join Date
    Dec 2002
    Location
    Préverenges, Switzerland
    Posts
    3,740
    make a new hidden textbox
    .value is "*" & yourOriginalTextBox & "*"
    have your query look at this hidden textbox as Like criteria

    or code-up the SQL directly... makes it easy to add a like/exact checkbox

    izy
    currently using SS 2008R2

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •