Restrict data entry to preset list

[chrisfl]

I'm sure this is pretty easy to figure out but I can't figure out how to phrase it for googling. I want an address field to draw from a list of preexisting addresses, so my data entry people aren't, for example, using 123 Fake Street vs. 123 Fake St. I'd like it if the appropriate address popped up as they type, like 123--- would be sufficient.

Thanks!

[NTC]

Depending on where you want to implement this would change the specifics of the advice, so this may not be exactly what you want...but generically speaking; Microsoft recommends that novices use the LookUp field type when creating the table that is going to hold the data. One then has a separate table which exists with those addresses. One of the options in this field time is 'Limit to List'.

When this field type exists in the table - then all the forms you create (sourced on this table) will automatically have drop downs (comboboxes) for this field.

Hope this helps a little

[June7]

Lookups set in tables do serve to facilitate quick build of comboboxes if the field is selected and dragged from field list or use form build wizard. However, lookups can be annoying when viewing tables. As a developer, I want to see actual values when I view tables.

For background on 'lookups' review:
http://access.mvps.org/access/lookupfields.htm
http://compgroups.net/comp.databases...y-evil/1485465

For tutorials on comboboxes:
http://datapigtechnologies.com/AccessMain.htm
Go to the section on Access Forms: Control Basics