Search for Customer by its CompanyName

Topic

New Reply

Search for Customer by its CompanyName

I have a form based on the table Customers, each customer having unique ID Number.
However i want to search the customer not by its unique Customer ID Number, but by
typing the name of its company name on a control of the form. Is it possible
to search a customer by its CompanyName?

Reply | Quote

Replies

If the Company Name is also a field in this table, an easy way is to click in the Company Name field on a form which is based on the Customer table, then click the Find tool on the toolbar. The resulting recordset will be all the customer records with that Company Name. You can use the navigation buttons at the bottom of the form to move between all the records that meet this Company Name criteria.

Reply | Quote

When you are selecting the fields for your Combo Box to be used to do your lookup, select the unique ID to be used as the first column and the customer’s last name as the second column. Set the column width for the column containing the unique ID to 0″ and then the name column is the one you will see and when you start typing the name of the customer you will move quickly to the right record. It also works best if your form is based on a query that is sorted in Customer name order so all the customers are arranged alphabetically when you start searching for the one you want.

Reply | Quote