Form functions = shortcuts

H

HRP

How do I set up a form so that fields like "city" fill in automatically once
i start typing. For example, if i often enter a city name like "salt lake
city" can i set a field so that it expands to the full name.
 
A

Al Camp

A combo box for City with AutoExpand = Yes will try... as you type... to
figure out which City from it's list is a match.

You can set the query behind that combo to use all the Cities you've
entered in your recordset so far as the "master" listing.

Set LimitToList to No, and a new City can be added at anytime.
 
Top