Results 1 to 4 of 4
  1. #1
    Kirtap is offline Novice
    Windows 7 64bit Access 2010 32bit
    Join Date
    Oct 2013
    Posts
    22

    Possible to have a suggestion list feature based upon what a person previously typed?

    Hello,

    Let me describe the situation.
    I have a subform containing maintenance logs for pieces of equipment, viewed as a Datasheet.
    I have a field called Comment accepting text. Since comments are similar, it would be nice to have a drop down list so the user can select what was previously typed in other records and then edit it from there, similar to how Google or search engines in its search text box generates as part of its suggestion list the previous searches after typing in the first few matching characters.

    I tried looking through, but is there a property that does this?

    Sorry if its a bad question and its not necessary I include this feature, but I was just curious if its possible.



    Thank you in advance.

    Edit: Sorry if I placed this in the wrong section.
    Last edited by Kirtap; 11-20-2013 at 01:36 PM. Reason: May have placed this in the wrong section.

  2. #2
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,521
    One way would be to use a combo that either got its selections from a table specifically created for this purpose, or from previous entries in the form's source table.
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

  3. #3
    Kirtap is offline Novice
    Windows 7 64bit Access 2010 32bit
    Join Date
    Oct 2013
    Posts
    22
    Hi, sorry for the bump.

    Thanks for the suggestion!

  4. #4
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,521
    Happy to help!
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

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

Similar Threads

  1. Looking for db design suggestion
    By Jamescdawson in forum Database Design
    Replies: 2
    Last Post: 08-14-2012, 10:37 AM
  2. Replies: 6
    Last Post: 07-10-2011, 05:33 PM
  3. Replies: 3
    Last Post: 05-26-2011, 12:52 PM
  4. I need suggestion in SQL
    By genesis in forum Access
    Replies: 0
    Last Post: 07-31-2009, 08:17 PM
  5. Need suggestion or help please
    By KLynch0803 in forum Programming
    Replies: 14
    Last Post: 06-11-2009, 10:21 AM

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