SOLVED:Get RowNumber

Hi!


Just wanna know on how to get the rownumber of the created row number column..

for example i have declared the .CreateRowNumberColumn then in BeforeDrawRow i want to get the rownumber value of created row number.


Thank you!

hi Aaron.. thank for your reply..

i have tried the Debug.Print Row.Record.Index in BeforeDrawRow event... but ive got
error: object variable or with block variable not set.

thank you.... please i really need help on this..

Hi Aaron' Thank you so much... ive figured out the problem.... below are my solution... please advice if im mistaken something... i put a condition if Not Row.Group coz i added a grouporder.

    If Not Row.GroupRow Then
        If Row.Record.Index < rs.RecordCount Then
            rs.AbsolutePosition = Row.Record.Index + 1: rs.Move 0
            Row.Record(COLUMN_ICON_STATUS).Tag = rs.Fields![POSTED]
            With Row.Record(COLUMN_ICON_STATUS)
                Select Case .Tag
                    Case "P"
                        .Icon = RECORD_BLUE_ICON
                        .ToolTip = "Posted"
                        Row.Record(COLUMN_KMDIST).Editable = False
                    Case "R"
                        .Icon = RECORD_RED_ICON
                        .ToolTip = "REMARKS:" & vbCrLf & rs.Fields![REMARKS]
                    Case Else: .Icon = RECORD_GREEN_ICON
                End Select
            End With
        End If
    End If


thank you!

Hi,