Compile error:Method or data menber not found.
Any ideas what's wrong with this coding?

VB Code:
  1. Option Explicit
  2. Private cn As ADODB.Connection
  3. Private rs As ADODB.Recordset
  4. Private total4
  5. Dim temp, mov
  6. Dim DataMember As String
  7. Dim Data As Object
  8.  
  9.  
  10. Private Sub Form_Load()
  11. Set cn = New ADODB.Connection
  12. cn.Provider = "Microsoft.Jet.OLEDB.4.0"
  13. cn.Open App.Path & "./Car Rental.mdb"
  14.  
  15. Set rs = New ADODB.Recordset
  16. rs.Open "Customer", cn, adOpenStatic, adLockOptimistic, _
  17. adCmdTable
  18.  
  19. Set Text1.DataSource = rs
  20. Text1.DataField = "CustID"
  21. Set Text2.DataSource = rs
  22. Text2.DataField = "CustFname"
  23. Set Text3.DataSource = rs
  24. Text3.DataField = "CustLname"
  25.  
  26. Call GetDataMember
  27. d.Caption = rs.total4 '<------- error source
  28.  
  29. End Sub
  30. Private Sub GetDataMember()
  31.  
  32. Set Data = rs
  33. temp = rs.RecordCount
  34.  
  35. If temp < 2 Then
  36.  mov = temp & " Customer "
  37. Else
  38.  mov = temp & " Customers "
  39. End If
  40.  
  41. total4 = "Total " & mov & "in the database."
  42.  
  43. End Sub