Multiple Sorts

R

Rick Vooys

Good Day,

I have a report which display a list of two types of pieces (SpecID) and
the sizes of each piece that have to be built (PartWidth and ParthLength). I
have a GroupHeader for the (SpecID) so each displays in it's own group. The
problem is the users build each a bit different so it is easier for them to
have the "Slab" pieces sorted by Width and the "Drawer Fronts" sorted by
PartLength. I tried to include in the SpecID header the following code

If strFrontStructure = "Slab Door" Then

Me.GroupLevel(0).ControlSource = "PartWidth"
Me.GroupLevel(0).GroupOn = 0
Me.GroupLevel(0).SortOrder = False

Else

Me.GroupLevel(0).ControlSource = "PartLength"
Me.GroupLevel(0).GroupOn = 0
Me.GroupLevel(0).SortOrder = False

End If

But I get an error saying I can not set this during the format of the
report, or something similar. Now is there anyway to accomplish this using
the group level, did I put the code in the wrong event? Or should I look at
another way of doing this? Any ideas? Thanks ahead of time.

-Rick
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Grouping and Sorting a Report On Open Event 5
Detail sort in report using code 2
help on report sort order 8
Rogue Parameter Value 2
Dynamic Sorting and Query 2
ControlSource on text box in Group Header 1
not able to select in option group 1
Data type mismatch when passing String sort field to report 1

Top