Calculated fields and level of security in Access 2003

[chavnick via AccessMonster.com]

I have Access 2003. When I choose medium security level of macros the
calculated fields in my form show as #name or #err. When I choose low level
of security of macros are working properly. Why? I have 4 calculated
fileds. The 1rst named TotalCharge=IIf([BformPatWorks].Form.RecordsetClone.
RecordCount=0;0;[BformPatWorks].Form!TotalCharge) shows #name for example.
The 2nd named FinalPay=IIf([BformPayments].Form.RecordsetClone.
RecordCount=0;0;[BformPayments].Form!FinalPay) shows #name.The 3rd named Rest
(=[TotalCharge]-[FinalPay] shows #err. The 4rth named TotalDiscount=IIf(
[BformPatWorks].[Form].[RecordsetClone].[RecordCount]=0;0;[BformPatWorks].
[Form]![TotalDiscount]) shows #name error. Is there an other solution? Thank
you.

 

[Crystal (strive4peace)]

I always set security level to low ... to me, there is absolutely NO
reason to block macros and code in Access

Warm Regards,
Crystal
remote programming and training

http://www.YouTube.com/user/LearnAccessByCrystal

Access Basics
http://www.AccessMVP.com/strive4peace
free 100-page tutorial that covers essentials in Access

*
have an awesome day
*

 

[chavnick via AccessMonster.com]

I always set security level to low ... to me, there is absolutely NO
reason to block macros and code in Access

Warm Regards,
Crystal
remote programming and training

http://www.YouTube.com/user/LearnAccessByCrystal

Access Basics
http://www.AccessMVP.com/strive4peace
free 100-page tutorial that covers essentials in Access

*
have an awesome day
*

I have Access 2003. When I choose medium security level of macros the
calculated fields in my form show as #name or #err. When I choose low level

[quoted text clipped - 7 lines]

[Form]![TotalDiscount]) shows #name error. Is there an other solution? Thank
you.

Thank you for your advice.

 

[Crystal (strive4peace)]

you're welcome

Warm Regards,
Crystal
remote programming and training

http://www.YouTube.com/user/LearnAccessByCrystal

Access Basics
http://www.AccessMVP.com/strive4peace
free 100-page tutorial that covers essentials in Access

*
have an awesome day
*

I always set security level to low ... to me, there is absolutely NO
reason to block macros and code in Access

Warm Regards,
Crystal
remote programming and training

http://www.YouTube.com/user/LearnAccessByCrystal

Access Basics
http://www.AccessMVP.com/strive4peace
free 100-page tutorial that covers essentials in Access

*
have an awesome day
*

I have Access 2003. When I choose medium security level of macros the
calculated fields in my form show as #name or #err. When I choose low level

[quoted text clipped - 7 lines]

[Form]![TotalDiscount]) shows #name error. Is there an other solution? Thank
you.

Thank you for your advice.