Re-sorting fields in form view

  • Thread starter Thread starter Jack Sheet
  • Start date Start date
J

Jack Sheet

Hi all
I have a v simple database, with a table that can be viewed either as
datasheet view or form view.
In Datasheet view I resort the records on a particular field.
But then when I go to form view I want the records to be sorted in the same
way as the revised sort in Datasheet view. However the records remain
sorted in the order in which they were created. How do I correct this,
please?
I am currently using Office 97 but will upgrade shortly to Office 2003.
However the database is written in Office 97 for now.
 
Jack Sheet said:
Hi all
I have a v simple database, with a table that can be viewed either as
datasheet view or form view.
In Datasheet view I resort the records on a particular field.
But then when I go to form view I want the records to be sorted in the
same way as the revised sort in Datasheet view. However the records
remain sorted in the order in which they were created. How do I correct
this, please?
I am currently using Office 97 but will upgrade shortly to Office 2003.
However the database is written in Office 97 for now.
Click to expand...

Bind your form and datasheet view to the same query.

Regards,
Keith.
www.keithwilby.com
 
Back
Top