report!

[Sam Hung]

Hi,

It'll be great if the person Allen Browne receives this
message. Last time I asked about report filtering, and
you gave me the source code like as belows. It did work,
but the data is not in correct order. I'm wondering
whether something like sorting has been set inside. The
data should be same as data filtering in forms.

Dim strWhere As String
If Me.Dirty Then 'Save any edits.
Me.Dirty = False
End If
If Me.FilterOn Then
strWhere = Me.Filter
End If
DoCmd.OpenReport "MyReport", acViewPreview, , strWhere

--
Allen Browne - Microsoft MVP. Perth, Western Australia.


Thanks,
Sam.

 

[Duane Hookom]

Sorting in reports is only reliable using the sorting and grouping in the
report. Check the link to Allen's web site in this thread.

_____________
Duane Hookom
MS Access MVP