Change sort order (1 Viewer)

[angelac]

Right now I have a form that sortsrecords based on customer ID. I need it to sort by Last Name. This seems easy but nothing I've tried works. Why is it sorting by ID anyway. The form is based on a table and I've set the table to sort by last name. Please help, somebody!

 

[AlanS]

Look in Access help under the topic "OrderBy Property".

 

[angelac]

That was the first place I looked. Even when I change this property on the form, it still orders by customer ID.

 

[capri]

Try this

In design view right click on the property sheet for the entire form (the small black box in the top left corner. You will see a menu that lists properties. Right above the properties is a choice "sorting and grouping". Click on this item. Under Field click the down arrow and select the field you wish to sort by. You can also choose sort order. Close and go look at your form. It should be sorted the way you selected.

 

[Angello Pimental]

What are you trying to accomplish with this sort??
Are you trying to create a search in which a user can look up records based on what last name they select?
If you could give us more details, the easier it will be for us to assist you.

Angelo