Re-sorting fields in form view

[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.

 

[Keith]

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.

Bind your form and datasheet view to the same query.

Regards,
Keith.
www.keithwilby.com

 

[Jack Sheet]

Great, thanks, just the job

Bind your form and datasheet view to the same query.

Regards,
Keith.
www.keithwilby.com