M
Mark A. Sam
I am having an issue with calulated fields in some forms with calulated
fields where the tables are linked SQL Server tables. For example, on one
continuous subform, I have a method to bring up a popup form in a field.
After closing the popup, another (calculated =DLookup(<expression>)) turns
into #Error.
On another form a calculated field with (=Sum({field])) turns into #Error on
some records but not all. If I click on the subform and click F9 to recalc
or cause a recalc by entering data into a field, the form it clears it up on
that record for the main form. Changing records on the main form, that
#Error will appear or not for no apparent reason.
There is nothing I can identify in the data for a clue.
Any help is appreciated.
God Bless,
Mark A. Sam
fields where the tables are linked SQL Server tables. For example, on one
continuous subform, I have a method to bring up a popup form in a field.
After closing the popup, another (calculated =DLookup(<expression>)) turns
into #Error.
On another form a calculated field with (=Sum({field])) turns into #Error on
some records but not all. If I click on the subform and click F9 to recalc
or cause a recalc by entering data into a field, the form it clears it up on
that record for the main form. Changing records on the main form, that
#Error will appear or not for no apparent reason.
There is nothing I can identify in the data for a clue.
Any help is appreciated.
God Bless,
Mark A. Sam