Query Putting Contacts in Alphabetical Order, But....

[Richie2837]

Our Contacts database main form displays all our contacts based on a query which is simply putting all the contacts in the tablke into alphabetical order by surname. I've just noticed that any new contacts that are input are added to the end of the list as they are displayed on the form, despite the alphabetical ordering on the query. What have I done wrong? Also, how can I get the query to sort alphabetically by surname first then by first name?

 

[ColinEssex]

Use the "OrderBy" in the forms properties

Col

 

[Richie2837]

Hi Colin,

The form's properties are already set to do this.

 

[Dennisk]

you need to requery after adding a record

if the query is the recordsource forr the form then me.Requery should do the job.

 

[Richie2837]

Where would I put this control?

 

[Dennisk]

its not a control
When I develop a form I always place a save button in the form footer so that is where I would place the code. However if you do not have a save button then insert the code in the forms After update event.

 

[Richie2837]

I do have a save button on the form - does the code go into the On Click properties?