J
jesse
Hi Everyone,
I've searched this group and found many messages I thought would help
but I'm still stuck. Here's the situation.
This is an ADP project in Access 2000 against SQL Server 2000
I have a main form that has a subform
The subform is linked to the mainform by a single column
The subform data is based on a view. The view simply retrieves all of
the columns from a single table.
When the subform is first displayed based on the main form all of the
subtotals on the subform are fine
When I edit the note column in a row in the subform and then click to
another row in hte same subform to trigger an update the subtotals are
still fine. The "note" column is of type "text" in the SQL Server
table.
If I do a recalc on the subform by clicking the F9 key or adding code
to the AfterUpdate to "Me.Recalc" the subtotals show "#Error". Also, if
I don't do anything with recalc and just change to row on the main form
which refreshes the subform the subtotals show "#Error". I've also
tried putting in code to Requery the subtotal columns after the update
of the "note" column but that didn't work either.
This only happens when the "note" column is edited. All of teh other
columns can be changed and saved just fine. I'm wondering if there's
something strange about teh behavior of a text column in the SQL Server
table and Access 2000.
Any help would be appreciated.
Thanks,
Jesse
I've searched this group and found many messages I thought would help
but I'm still stuck. Here's the situation.
This is an ADP project in Access 2000 against SQL Server 2000
I have a main form that has a subform
The subform is linked to the mainform by a single column
The subform data is based on a view. The view simply retrieves all of
the columns from a single table.
When the subform is first displayed based on the main form all of the
subtotals on the subform are fine
When I edit the note column in a row in the subform and then click to
another row in hte same subform to trigger an update the subtotals are
still fine. The "note" column is of type "text" in the SQL Server
table.
If I do a recalc on the subform by clicking the F9 key or adding code
to the AfterUpdate to "Me.Recalc" the subtotals show "#Error". Also, if
I don't do anything with recalc and just change to row on the main form
which refreshes the subform the subtotals show "#Error". I've also
tried putting in code to Requery the subtotal columns after the update
of the "note" column but that didn't work either.
This only happens when the "note" column is edited. All of teh other
columns can be changed and saved just fine. I'm wondering if there's
something strange about teh behavior of a text column in the SQL Server
table and Access 2000.
Any help would be appreciated.
Thanks,
Jesse