Sort a form using multiple fields

[dickjo5]

I am definitely a newbie when it comes to Access, but I do have a small data base with a couple of tables and one form. The form contains all the fields in the primary table, which I can sort by using two fields (lname, fname). I can sort information in the Form on only one field. Consequently, the lname field sorts fine, but fname seems to be in order the record was created. I have many Smiths and desire the fname field be sorted, also, so I don't have to search through all of them manually.
I have one Primary Field which is MemberID.
I sort the table using the two fields and it works great, but when I go to the Form format, nothing has changed.
Any help would be appreciated.
dickjo5

 

[Rich]

Base the form on a query and order by the required fields

 

[dickjo5]

Thanks for the prompt reply Rich.
Will I have to create the form all over, or is there some way I can copy and relate the one I have to the new query?

 

[Rich]

If the fields in the query are the same you'll only have to change the forms recordsource to the query

 

[dickjo5]

Works like a charm. Many thanks.