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

Sorting and Grouping Report - Please HELP!

P: n/a
Hi Guys,

My "Sorting and Grouping" in my report looks like this:

Field/Expression Sort Order
sID Ascending
((= Project Name Ascending
User *** Ascending
((= rID Ascending

The "((=" is Group Header = Yes

I have a form that has a 'create report' button that opens this report.

I am trying to make a list/combo box in the same form that the user can choose a field and when they click the 'create report' button it will change the third field (***) to whatever the user selected in the list.

eg. i want to be able to have the same report sorted by Priority or Status or User etc...

Is this possible? does anyone know the code i can use in the 'create report' button...

Thanks for any suggestions!

--
Message posted via http://www.accessmonster.com
Nov 13 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
Here is an example from the Help file that I believe does what you are
asking.

Private Sub Report_Open(Cancel As Integer)
Me.GroupLevel(0).ControlSource _
= Forms!SortForm!txtPromptYou
End Sub

The index number for the third group, where you have User, would be 2. You
can also add a new group level with the CreateGroupLevel method of the
Application object.

--
Wayne Morgan
MS Access MVP
"Jon via AccessMonster.com" <fo***@AccessMonster.com> wrote in message
news:a7******************************@AccessMonste r.com...
Hi Guys,

My "Sorting and Grouping" in my report looks like this:

Field/Expression Sort Order
sID Ascending
((= Project Name Ascending
User *** Ascending
((= rID Ascending

The "((=" is Group Header = Yes

I have a form that has a 'create report' button that opens this report.

I am trying to make a list/combo box in the same form that the user can
choose a field and when they click the 'create report' button it will
change the third field (***) to whatever the user selected in the list.

eg. i want to be able to have the same report sorted by Priority or Status
or User etc...

Is this possible? does anyone know the code i can use in the 'create
report' button...

Thanks for any suggestions!

--
Message posted via http://www.accessmonster.com

Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.