Problem with setting a form's recordset

[Guest]

I am having a problem with assigning an in memory ado recordset to a form

'grstGLDistribution is declared as public in the declarations section of a module

Here is the recordset
With grstGLDistributio
..Fields.Append "strBatch", adVarChar, 2
..Fields.Append "strAccountID", adVarChar, 2
..Fields.Append "strDescription", adVarChar, 5
..Fields.Append "curDebit", adDoubl
..Fields.Append "curCredit", adDoubl
..Fields.Append "strDepartmentID", adVarChar,
..Fields.Append "strReference", adVarChar, 7
..Fields.Append "strAccountType", adVarChar, 1
..Ope

I then add seven records (rows) to the recordset

I then assign the recordset to the continuos form

Set Me.Recordset = grstGLDistributio

Here is the problem: the form displays all seven rows but all the values display as #Error

I can use the immediate pane and check the actual field values in grstGLDistribution and they are correct. Why are they showing up as #Error on the form??? I have made double sure that the fields on the form are bound to the correct names

Thanks for any help.

 

[Guest]

This is in an Access 2003 ADP

Thanks for any help.