I wonder if you can help me.
I have setup an address-book database in Access XP. I have the first name &
surname as separate fields. As I wanted to sort my database by surname and
then by first name I had surname before first name when I created the
fields of my database..
To do the sort (in table view) I highlighted the two columns (fields), in
this case surname and first name, and selected sort. Access then sorted the
database by surname and then by first name. When I viewed the database in
table view it was sorted exactly the way I wanted it.
However, when I looked at the database in a form it did not show the records
in the order it did in table view, I think the form displayed the records
just sorted by surname.
The reason I want to sort by surname and first name is because sometimes I
have two entries for the same person; 1 address may be home address and the
other a work address.
What I am trying to do is to make sure that records with the same names are
consecutive rather than having other record(s) in between. I have achieved
this in the table view but am struggling to do it in form view
..
Why do the records in form view appear in a different order to how I sorted
them in the table?
How can I make my form display the records in the sorted way I want?
I hope you can help me.
I appreciate any help or information given.
Thanks!
--
-------------------------------------------------------------------------
FIGHT BACK AGAINST SPAM!
Download Spam Inspector, the Award Winning Anti-Spam Filter
http://mail.giantcompany.com