Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2017
    Posts
    1

    Unanswered: Multi Input in text Search box

    Hi,

    Can i know how to allow text box search can input multiple value that link to list box.
    I have attached my working file.
    Please advise.
    Thanks.
    Attached Files Attached Files

  2. #2
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    629
    Provided Answers: 34
    if you mean, you want to find : country = USA, or UK, or Germany,
    then you cannot use a text box.
    The BEST way is use a separate 'picked list' table. Join this table to your tData table and you get only those items.
    I use a list box, the user picks items from the list box,
    it runs an append query to add the value to the tPicked table.
    The final query pulls only those items.

    Click image for larger version. 

Name:	pick list names-lbls.png 
Views:	2 
Size:	61.0 KB 
ID:	17459

Posting Permissions

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