467,921 Members | 1,362 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 467,921 developers. It's quick & easy.

Sorting records using visual basic

I can open a form using a combo box to select a group of records.

stLinkCriteria = "[Tu]= '" & Me![PrintTu] & "'"
DoCmd.OpenReport stDocName, acPreview, , stLinkCriteria

[PrintTu] is what comes from the combo box.

I would also like the records to be sorted in an order not the same as the
underlying table. I would imagine this should be simple, but to me, and
amateur, it's not!

Thanks in advance for any help.
Nov 13 '05 #1
  • viewed: 1471
Share:
1 Reply
See:
Sorting Records in a Report at run-time
at:
http://allenbrowne.com/ser-33.html

The article explains how to programmatically set the ControlSource of the
GroupLevel in the report's Open event.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"John M" <jo**@jmawer.demon.co.uk> wrote in message
news:d3*******************@news.demon.co.uk...
I can open a form using a combo box to select a group of records.

stLinkCriteria = "[Tu]= '" & Me![PrintTu] & "'"
DoCmd.OpenReport stDocName, acPreview, , stLinkCriteria

[PrintTu] is what comes from the combo box.

I would also like the records to be sorted in an order not the same as the
underlying table. I would imagine this should be simple, but to me, and
amateur, it's not!

Thanks in advance for any help.

Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

40 posts views Thread by Elijah Bailey | last post: by
8 posts views Thread by Matthew Curiale | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.