Re: Access Sorting problem - please help!

Neil Hindry wrote:
> 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!
> 
Just came across this request and it's a bit dated. Have you fixed it. 
If not repost and I will answer.
drifter45