By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
446,397 Members | 1,461 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 446,397 IT Pros & Developers. It's quick & easy.

Sorting records using visual basic

P: n/a
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
Share this Question
Share on Google+
1 Reply


P: n/a
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.