Hi All,
I have a field in a form that updates based on a subform. When I click to enter a new record having a blank form, this field shows #error which is corrected as soon as the subform updates then works fine. I understand why the error happens since there is nothing to update but I do not want the end user to see this thinking there may be a problem with the form. Are there any work arounds here maybe using the Before Update function? I've tried some if statements using NZ but they do not seem to work.
Thanks in advance,
Eric