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...