Possible Bug? Me.Recordset doesn't work in Reports... need help.

  • Thread starter Thread starter James
  • Start date Start date
J

James

I'm writing code to fill in data on a report. This is what I've got:

Public Sub LoadData(childData As DataSource)

Set Me.Recordset = childData.Dataset

End Sub

It steps through .Dataset just fine, when it tries to move on it errors
out saying "Run Time error '2593' This feature is not available in an
MDB"

I use Me.Recordset in forms and it works just fine.

I've got to View -- Immediate Window and entered: ?me. and it finds
Recordset as a choice.

Does anyone have any ideas what's going on? Or have I totally lost
everyone? Thanks for the help.
 
Are the tables linked by chance? It's been a while but I seem to remember
something about problems with it and linked tables.
 
Reports do not expose the Recordset property to VBA, so you cannot set /
change the report's Recordset. You can set the report's RecordSource in the
report's Open event, but after that the RecordSource and the Recordset are
fixed and cannot be changed.
 
Back
Top