Results 1 to 5 of 5
  1. #1
    kjmikich is offline Novice
    Windows Vista Access 2010 32bit
    Join Date
    Dec 2011
    Posts
    2

    Want my form to auto suggest content

    My database is sent to me already formatted and ready to enter data in to. I have a name, address, phone, etc fields. I would like to have the name field auto suggest content based on what I had typed in the previous line. For Example: I type kathy on line one and go to line two and type a k and would like it to suggest (autofill) in the word kathy..

    This seems like it should be simple but I have not been able to find a solution.




    Please help me save a ton of time and learn how to do this.

    Kathy

  2. #2
    aytee111 is offline Competent At Times
    Windows 7 32bit Access 2010 32bit
    Join Date
    Nov 2011
    Location
    Nomad
    Posts
    3,936
    The name field must be a combo box.

    In the form properties, you need an event procedure for the AfterUpdate event which will say "Me![name].Requery" (without quotes)

  3. #3
    kjmikich is offline Novice
    Windows Vista Access 2010 32bit
    Join Date
    Dec 2011
    Posts
    2
    I wish I Understood your suggestion but I am a newbie to access. Is there any soft of documentation that you might point me at?

  4. #4
    dblife's Avatar
    dblife is offline Competent Performer
    Windows XP Access 2003
    Join Date
    Nov 2011
    Location
    South Shields, UK
    Posts
    104
    If you google 'cascading combo selection' you will find what youre looking for.
    Combo boxes allow you to select choices from a drop down on a form and can be made to do what you need them to do here..

  5. #5
    orange's Avatar
    orange is offline Moderator
    Windows XP Access 2003
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,726
    You say
    My database is sent to me already formatted and ready to enter data in to
    .

    Can you talk to the people/person who did the programming? Can you not ask for some changes?

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

Similar Threads

  1. Display web content on a form.
    By ser01 in forum Forms
    Replies: 3
    Last Post: 05-30-2011, 10:21 AM
  2. Replies: 4
    Last Post: 05-28-2011, 01:20 AM
  3. Replies: 1
    Last Post: 02-16-2011, 11:40 AM
  4. Suggest number based on already used numbers
    By Patience in forum Access
    Replies: 3
    Last Post: 06-16-2010, 04:26 AM
  5. Auto Suggest
    By Makem in forum Access
    Replies: 3
    Last Post: 11-16-2009, 08:53 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