open a report from continues form 1

[smayshar]

I have several continues forms and one general toolbar for all these forms that contain ms filter , a-z sorting ...
each one of the forms have a print button that opens a report.

how can i open the report with the same sorting that the user chose on the form ?

the filter works fine with the call :

DoCmd.OpenReport stDocName, acPreview, , Me.Filter
I itried : DoCmd.OpenReport stDocName, acPreview, Me.Filter - didn't work

 

[Gaffi1]

Have you checked the Sorting/Grouping properties of you report? When in design mode, right-click the upper-left-most square and open the dialog box. There, add the field that you wish to sort by, be it the name, record number or whatever, then ascending or descending.

Hope this helps!

 

[TheAceMan1]

How are ya smayshar . . . . .

In the [blue]Open event[/blue] of one of the reports try this ([blue]you[/blue] substitute proper form names in [purple]purple[/purple]):

[blue]   Dim Prp As Property
   
   Set Prp = Forms![purple][b]CallingFormName[/b][/purple].Properties("OrderBy")
   
   If Trim(Prp & "") <> "" Then
      Me.OrderBy = Prp
      Me.OrderByOn = True
   End If
   
   Set Prp = Nothing[/blue]

When your satisified, do the others . . . . .

See Ya! . . . . . .