"Order by" help needed for Access 2003 Report

[PZ Straube]

hello, I have a database of contacts. In one report, I have three alpha bars
to locate people based on last name, maiden name, or first name. After adding
the 2nd and 3rd bar, I can't get the names to sort the way I want. I believe
I need to use "Order By" with a macro or other expression that would be
triggered after clicking on a button (letter) of the alpha bar. Each bar
would trigger a different sort order so I would need three in total I'm at a
loss on this and I can't find any examples to helk me with this. Any help
will be appreciated. Thank you.

 

[Duane Hookom]

I'm not sure about others but I don't have a clue what "In one report, I
have three alpha bars" is. If your question is "How do I allow users to make
a selection on a form to set the sort order in a report" then check Allen
Browne's page at http://members.iinet.net.au/~allenbrowne/ser-33.html.

 

[PZ Straube]

Duane,
I apologize that I wrote Report instead of Form.
My question is how do I let a user work with three different alpha bars in a
form and when they click on a letter of any of the alpha bars, it will sort
the records based on the purpose of the particular alpha bar they used. For
example, if they use the Maiden Name alpha bar, the records will be sorted by
Maiden Name and show only records starting with that letter. Likewise, if
they click on a letter of the First Name alpha bar, the records are sorted by
First Name and show only records starting with that letter.
I hope I was clearer this time.
Thanks for your time in responding to my question.

 

[Duane Hookom]

I guess part of the confusion was that this is a Reports NG and you are
asking form questions. The Corp Tech Demos has a bar (long command button)
that displays letters of the alphabet as you mouse over. When you click a
letter, the appropriate records are found. Check it out at
http://www.invisibleinc.com/divFiles.cfm?divDivID=4