Hide Dlookup #error message on subform

[JennieL]

Hi:

I have a subform that uses Dlookup to find a value. When no value is found since there is no record created as of yet, the subform displays #Error.

I would like to hide this error and replace with a zero until records are created.

Any suggestions for me.

Thank you.

 

[PHV]

=Nz(DLookUp(....),0)

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[JennieL]

That worked perfectly.

Thank you very much....