Hello all. I am building an application that uses a MYSQL backend. I am unable to bind a report to an ADO recordset. Attempting to bind the reports record source property results in an "invalid use of property" error. Any help would be greatly appreciated.

Thanks a million

How are you doing the binding? I find something like this will generally work? Can you post the code?

Private Sub Form_Open(Cancel As Integer)

  Dim conn As ADODB.Connection
  Dim rs As ADODB.Recordset

  Set conn = CurrentProject.AccessConnection
  Set rs = New ADODB.Recordset
  With rs
    Set .ActiveConnection = conn
    .Source = "SELECT * FROM tblCompany"
    .LockType = adLockOptimistic
    .CursorType = adOpenKeyset
    .CursorLocation = adUseServer
    .Open
  End With
  'Set the form's Recordset property to the ADO recordset
  Set Me.Recordset = rs
  Set rs = Nothing
  Set conn = Nothing
End Sub



mmcdonal

Look it up at: http://wrox.books24x7.com