DLookUp Issue(?) In MS Access

0
votes

In MS Access form, I have this text field "Current Balance" in which it should look up for the value in the table 'attached' to it.

So, in its Control Source, I have 

=DLookUp([Balance],"Collections","")

It displays the balance from the table. But my problem is, when I go to the next record, the textbox "Current Balance" has a value that is #Error instead of the last value that was has been inputted. How could I address the said issue?

Thanks for your help

1
ms-access

1 Answers

1
votes

Use =Nz(DLookUp("[Balance]","[Collections]","")) to avoid the #Error. It is most probably caused by a Null value.