Northwind/Customer Phone List

  • Thread starter Thread starter C Tate
  • Start date Start date
C

C Tate

Hi

I am using the contact management template shipped with Access 2000. I
wanted a phone list similar to the Customer Phone List form in the Northwind
database. I decided to copy the macro and use it for my own form. My form
contains Company Name, FirstName, Last Name, Work Phone, and Fax. The
trouble is that when I click the 'all' button to see all my contacts they
are not sorted alphabetically. I THINK the reason for this is that the
contacts table has contact ID as the primary key (which is an autonumber).
But the Northwind Customer table has a primary key which is sort of
alphabetical and is text (not autonumber).

When I click the all button in my form the companies are therefore sorted by
the contact ID.

How can I get around this?
 
Instead of basing the form recordsource directly on a table, base it in on a
query. Then you can set the query to sort on anything you like, and the
form will follow.

--
Regards,

Adrian Jansen
J & K MicroSystems
Microcomputer solutions for industrial control
 
1) Click Records + Remove Filter/Sort

If that doesn't do it then it depends upon how
your Phone Book form is set up.

2) If the Customer Name field is not locked, then just select any name in
the Customer Name field and click the A-Z sort tool button.

3) If the Customer Name field is locked:
Open the form in Design View
Click on the Data tab.

In the Order By property line, write:
[NameOfTable].[CustomerNameField]

Save the changes.
 
Back
Top