Record Count

[Zippyfrog]

I have one more question about my report. I currently have a report that organizes records from smallest to largest, and I only want the 10 lowest to show. So I have the following hard coded into a report:

Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)

If txtRCount > 10 Then
Me.PrintSection = False
Me.MoveLayout = False
End If
End Sub

Is there a way I can reference a textbox value from another form so the user can choose how many records they want to have instead of me hardcoding in 10?

 

[pbaldy]

Have you considered limiting the records in the query using the TOP predicate? In any case:

If txtRCount > Forms!FormName.ControlName Then