#Error sign

[coolcatkelso]

Hiya guys

If I create a new customer on my DB, I get the #Error in one field.. Is there a way around this,

Here is the code behind that field -
=[Workorders by Customer Subform].[Form]![Text55]

Bit rough like, but it works lol
________
Ipad Guides

 

[RainLover]

You say it works, so what is the problem.?

 

[coolcatkelso]

Hiya m8

Yeah the code works, but if no records have been created or its a new cmr, then it displays the #error untill data is added?
________
California Dispensary

 

[boblarson]

Use the NZ function:

If the field is Text:
=Nz([Workorders by Customer Subform].[Form]![Text55], "")

If the field is numeric:
=Nz([Workorders by Customer Subform].[Form]![Text55], 0)