Results 1 to 3 of 3
  1. #1
    Snayjay is offline Novice
    Windows 7 64bit Access 2007
    Join Date
    Mar 2014
    Location
    Gulf of Mexico
    Posts
    10

    Question Listbox source query repopulates listbox as user types in textbox...

    Ok, let me explain this:

    Table Name: MAJORCODEtbl
    Field 0: MAJORCODE (Text)
    Field 1: MAJORCODENAME (Memo)

    Form Name: ACCTCODEfrm
    Object Textbox: SEARCHtb - just a textbox the user types in (the only thing the user interacts with
    Object Listbox: MAJORCODElb - a listbox whose RowSource is a query - from above table - showing both fields
    example
    Code:
      MajorCode  |  MAJOR CODE NAME
      7096000     |  Control Piping, Valves, Hoses
      7097000     |  Control Hose Bundles, Jumpers, Reels
      7098000     |  Control Pods
    We have over 400 codes; this form will help users find "Major Acct Codes" for the different pieces of equipment we use. So if a user didn't know Control Pods was 7098000, then he would type "Control" and all 3 of those would come up as he was typing, but after he typed "Control P" then 7097000 would disappear and then "Control Po" then 7096000 would disappear.

    I need the form to catch any of the words in the MAJORCODENAME field, NOT just from the beginning; so if the user typed "Reel", then 7097000 would show up.



    Appreciate the help.

    Snayjay

  2. #2
    ItsMe's Avatar
    ItsMe is offline Sometimes Helpful
    Windows 7 64bit Access 2010 32bit
    Join Date
    Aug 2013
    Posts
    7,862
    Maybe something like this
    Attached Files Attached Files

  3. #3
    Snayjay is offline Novice
    Windows 7 64bit Access 2007
    Join Date
    Mar 2014
    Location
    Gulf of Mexico
    Posts
    10
    Nice, simple example. Appreciate the help. Perfect solution.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Requery Does Not Update Listbox Row Source
    By szucker1 in forum Forms
    Replies: 7
    Last Post: 02-11-2014, 08:58 AM
  2. Replies: 8
    Last Post: 10-09-2013, 02:09 AM
  3. Replies: 3
    Last Post: 12-13-2012, 04:40 AM
  4. Replies: 1
    Last Post: 09-10-2012, 11:21 PM
  5. Replies: 1
    Last Post: 07-26-2012, 11:45 AM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums