Results 1 to 3 of 3
  1. #1
    Join Date
    Jul 2016
    Posts
    1

    Unanswered: Filter Listbox Using Textbox With Multiple Keywords And Separator

    Hi,

    I have unbound form with unbound text box and list box which is linked to table. I would like to know whether is it possible to filter multiple line items / records in list box by using keywords entered in text box.

    For Example:

    Table contains below record

    ID User EMPID
    1 John 480
    2 Alex 123
    3 Jana 789

    In unbound text box if i type as below (In Put), the line item in list box should show both records of John and Alex. Like:

    In Put: For more please look into snap shot.Click image for larger version. 

Name:	Capture.PNG 
Views:	0 
Size:	6.8 KB 
ID:	17066

    John
    Alex

    Result

    ID User EMPID
    1 John 480
    2 Alex 123

  2. #2
    Join Date
    Jun 2005
    Location
    Richmond, Virginia USA
    Posts
    2,763
    Provided Answers: 19
    Double-posted and answered here:

    Filter Listbox Using Textbox

    Linq ;0)>
    Last edited by Missinglinq; 07-30-16 at 18:30.
    Hope this helps!

    The problem with making anything foolproof...is that fools are so darn ingenious!

    All posts/responses based on Access 2003/2007

  3. #3
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    495
    Provided Answers: 24
    Why use a text box to type,when you can pick items from a list?
    The user can dbl-click the EMP from list, run an append query and the name will appear in a table.

    Or use vba code to add to a text box.

    Why type items that are already there to click?

Posting Permissions

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