View Full Version : Autocomplete text box


h82bl8
05-15-2001, 11:55 AM
I have a form that lets users track shipments by date, and I want to allow them to track by customer. Direct search by dropdown box or complete user fill-in is OK, but my intent is to have the user begin to enter a customer name, and to have the text box autofill the entire name if it exists in the database already.
Does anyone know if this functionality is possible in Access?

D B Lawson
05-15-2001, 02:05 PM
If you have a form which has fields for your customer's details, you can create a combo box using the wizard and select the 3rd option, find a record based on the option selected in the combo box. It will do the autofill as part of that. The other thing you can do is on the OnChange event of the combo box, add Me.[comboboxname].dropdown so that when the user starts to enter a name, the box drops down to show the selections available.