Results 1 to 3 of 3
  1. #1
    Victor93 is offline Novice
    Windows 10 Access 2016
    Join Date
    May 2019
    Posts
    5

    Autofill from same table and column

    Hi all.



    Newbie in Access here, I have a question about autofill.

    I am building a database for my commercial department. The main table has some basic contact fields for potential or current clients. One of those fields is the location (as city, or town...) of the client. When we introduce a new entry and we write the location, it would be very helpful if the cell suggested an autofill option if the name of the town we want to introduce is already introduced (for instance, if the town is "Medina del Campo", that it suggests the full name only by writing "Med" or something like that). This works in excel, and it is great, as some of the towns have very long names. Also, it would avoid typos.

    How can I do this? I have tried comboboxes. And I think I should do something like "look for the entries in table -client list-, column 3 -location-; and allow for new entries". But it does not work. First, it doesn't allow me to set -yes- to "allow new entries", it says something about the width of the column and I have no idea how to fix it (i can try to translate of look for this error in english if you need, my main language is spanish). Also, in my best result so far the autofill almost works, but it shows me the 1st column (which is the client name), not the 3rd (the location).

    Any clues on how can I do this? I'm sure it can't be that difficult...

  2. #2
    Minty is offline VIP
    Windows 10 Access 2016
    Join Date
    Sep 2017
    Location
    UK - Wiltshire
    Posts
    3,001
    To get your towns "existing list" use something like
    Code:
    SELECT Town FROM tblContacts GROUP BY Town ORDER BY Town
    In the combo row source.

    Because this is a grouped query you can't easily "add" data to it.
    You can set it to limit to list No and it should let you put anything you like in it. (Maybe)
    DLookup Syntax and others http://access.mvps.org/access/general/gen0018.htm
    Please use the star below the post to say thanks if we have helped !
    ↓↓ It's down here ↓↓

  3. #3
    Victor93 is offline Novice
    Windows 10 Access 2016
    Join Date
    May 2019
    Posts
    5
    That worked perfectly, thanks a million Minty.

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

Similar Threads

  1. Replies: 1
    Last Post: 01-18-2017, 10:29 AM
  2. Replies: 1
    Last Post: 02-14-2015, 02:29 AM
  3. Autofill one column from another
    By feinj in forum Queries
    Replies: 11
    Last Post: 06-19-2014, 02:14 PM
  4. Replies: 4
    Last Post: 09-04-2013, 06:40 AM
  5. Replies: 7
    Last Post: 02-10-2012, 08:08 PM

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