help again

[ARC]

If no one can figure out the last, then how would you use one report with a
few different sorts? I really don't want to do 3 separate reports since the
data is the same, etc. Hopefully I can find an answer for this today, as
it's the last thing on my list.

Thanks!

Andy

[lyle fairfield]

"ARC" <PC*****@PCESoft.invalidwrote in
news:Oh*****************@nlpi065.nbdc.sbc.com:

If no one can figure out the last, then how would you use one report
with a few different sorts? I really don't want to do 3 separate
reports since the data is the same, etc. Hopefully I can find an
answer for this today, as it's the last thing on my list.

Thanks!

Andy

In Northwoods 2007 there is a report called Customer Address Book. It is
grouped on [File As].

If we

1. Open the Report in Design View and set its "Has Module" Property to
True;
2. Run this code

Sub CustomerAddressBook1()
With [Report_Customer Address Book]
.GroupLevel(0).ControlSource = "First Name"
.Visible = True
End With
End Sub

The report opens sorted by First Name.

Depending upon your report and the version of Access you are using you may
have to adjust the syntax.

I am sorry that this code is so short and simple. Probably someone will
come up with a verbose and complicated solution of many lines, and as such
it will find favour here.

--
lyle fairfield