I am new to MS ACCESS
I used FAQ702-6025 for populating a list, but I need to create a serial number column for items shown in the listview.
If CmbComName > 0 Then
varWhere = varWhere & "[CustID1]= " & Me.CmbComName.Column(0) & " AND (([Contacts.ContactID])>=1) AND ((ResetRowNumber1())<>False);"
End If
I have above code with RowNumber1 and ResetRownumber1 as functions. above code is not not adding 1,2,3,4 serial in column "Line #" in the listview
Help is greatly appreciated.
I used FAQ702-6025 for populating a list, but I need to create a serial number column for items shown in the listview.
If CmbComName > 0 Then
varWhere = varWhere & "[CustID1]= " & Me.CmbComName.Column(0) & " AND (([Contacts.ContactID])>=1) AND ((ResetRowNumber1())<>False);"
End If
I have above code with RowNumber1 and ResetRownumber1 as functions. above code is not not adding 1,2,3,4 serial in column "Line #" in the listview
Help is greatly appreciated.