Starting a form in alphabetical order

[brock]

I have one table in which a form is based on. It has a index number in which in sorts by, the table contains names of people. I want the form to open in alphabetical order sorting by Last Name and First Name. If anyone knows, and I'm sure 99% of you do could you please dumb it down a shade for me thanks for all your help.

 

[rich.barry]

On the form properties, set OrderBy equal to [FirstField], [SecondField]

Main issue with this is that if someone resorts it and saves the changes to the form, you end up with some other sort.

One way round it is to put a Form_Load event with the code (example)

Forms!form1.OrderBy = "[FisrtField], [SecondField]"
Forms!form1.OrderByOn = True

This means that every time the form is opened, it sets the sort to the correct order.

[This message has been edited by rich.barry (edited 09-20-2001).]

 

[brock]

thanks