Results 1 to 3 of 3
  1. #1
    3 Star Lounger
    Join Date
    Jan 2001
    Posts
    254
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Search for Customer by its CompanyName

    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?

  2. #2
    3 Star Lounger
    Join Date
    Dec 2000
    Location
    USA
    Posts
    379
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Search for Customer by its CompanyName

    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.

  3. #3
    3 Star Lounger
    Join Date
    Dec 2000
    Location
    Manassas, Virginia, USA
    Posts
    363
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Search for Customer by its CompanyName

    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.
    Judy Jones, Computer Training Specialist
    Manassas, Virginia

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •