Results 1 to 4 of 4
  1. #1
    Join Date
    May 2013
    Posts
    19

    Find as you type textbox to combobox

    I have been working with allen brownes App Find As you Type in the link below and it works perfectly. I was wondering if anyone could help me modifly slightly. I have changed the search box into a combo box. I was wondering if it was possible to have the values in the form that are being filtered by the search box display in the combobox that way I could select and "jump to" the record. My one thought was to have the combobox display the values in the form, is that possible?



    http://allenbrowne.com/AppFindAsUType.html

    Any suggestions would be greatly appreciated

    Thank you
    Michael

  2. #2
    rpeare is offline VIP
    Windows XP Access 2003
    Join Date
    Jul 2011
    Posts
    5,442
    a combo box already behaves as a find as you type search, you just have to change your combo box to an unbound control so that in the on exit (for example) property it goes to the record you want.

  3. #3
    Join Date
    May 2013
    Posts
    19
    Sorry I should have been a little more clear. A combobox provides "starts with" search functionality but I would like to have "contains" hopefully that clarifies

  4. #4
    rpeare is offline VIP
    Windows XP Access 2003
    Join Date
    Jul 2011
    Posts
    5,442
    Ah, I don't think you can combine the functionality of a combo box with searching any part of the string, the best you can do is to likely have a combo box that has a search criteria based on the contents of your search window and, subsequently, if the search result is only one record the item is automatically selected and your form updated.

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

Similar Threads

  1. Textbox instead of Combobox
    By jzacharias in forum Forms
    Replies: 4
    Last Post: 10-24-2012, 08:57 PM
  2. Date - Textbox type mismatch 13
    By mdex in forum Programming
    Replies: 7
    Last Post: 01-20-2012, 08:44 AM
  3. Cannot type in form with combobox
    By fuller in forum Access
    Replies: 8
    Last Post: 12-09-2011, 10:32 AM
  4. Replies: 1
    Last Post: 12-17-2010, 04:25 PM
  5. Find as you type
    By pkstormy in forum Code Repository
    Replies: 0
    Last Post: 08-31-2010, 04:51 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