Alphabetical Order Query

[Richie2837]

The main form of our contacts database has its source in a query which places all contacts in alphabetical order by surname. How do I get the query to sort by surname and then by first name? Also, how can I get the query to run each time a new contact is added so they are put into alphabetical order when they are saved, rather than appearing at the end of the list?

 

[boblarson]

1. Open the query in the QBE grid and make sure that you have the surname column before the first name column and then set each, the sort order, to Ascending.

2. Within your form, in the AfterUpdate event of the form you can use Me.Requery to requery the form and that should put them into the correct order.

 

[Richie2837]

Thanks Bob, works a treat!