How to get rid of error msg on a field

[jdcallejas]

Hello,

I have created a dlookup field on a form and a calculated field that calculates the number on the lookup *2. Now when I first open the form on data entry there is no record selected so I get en error on the fields. This is because there is no data yet. So how can I get rid of the error and maybe put a Zero instead?

Thanks,

Daniel

 

[rainman89]

take a look at the nz function