I am an Access 97 user.

I would like to create a form that has both a customer ID and customer name on it. I would like the form to automatically fill in the customer's name once the user puts in the customer ID. When doing research (the Access 97 Bible) on this, the only info. that I get is to create a lookup wizard. This would cause the user to scroll down all of the cust. ID's to find the correct one.

We have over 1000 customers, if I do this, the users will be spending half of their day scrolling down for the ID's.

Does anyone know any code, that will automatically allow me to do an autofill without the lookup wizard?

Thanks

I assume that you have a table with CustomerId and CustomerName as fields.

Create a combo box on a form with the wizard with two columns of data, CustomerID and CustomerName. Set the bound column to CustmerID and hide the CustomerName.

Create a textbox on your form. On the event comboBox_AfterUpdate, store
combobox.column(1) in the text box.

You'll get the name very quickly.

Will this work for filling in all fields related to one person or is there another method?

Thanks,

Scott