Sorting in forms

W

William5271

I am administrating a medical contact database. We want the entries to be
alphabetatized by last name, then first name. A query of the databse sorts it
this, but the main form doesn't. How can I force the form to keep things in
oder this way.

Thanks
 
F

fredg

I am administrating a medical contact database. We want the entries to be
alphabetatized by last name, then first name. A query of the databse sorts it
this, but the main form doesn't. How can I force the form to keep things in
oder this way.

Thanks
Click to expand...

Use the query as the record source for the form.
Include all of the fields used in the form and sort it the way you
wish.
 
W

William5271

Is there a way to do that without redesigning the form? Can I resassign all
of the feilds to the correct data so
 
F

fredg

Is there a way to do that without redesigning the form? Can I resassign all
of the feilds to the correct data so
Click to expand...

You're not re-designing the form.
Just create a query (as you now have) using the fields you want in the
form. Sort the query as you will, i.e.

Select TableName.* from TableName Order by TableName.[LastName],
TableName.[FirstName];

On your current form, simply change the record source (it's on the
property sheet's Data tab) from the table to this query. It will take
5 seconds. Nothing else need be done.
 
Top