L
LMM
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.
'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.