I have an unbound textbox.
Its control source is =DLookUp("CountOfStatus","qry_MyCountStatusOpen")
I set the "default value" to 0 in the properties.
What I need: If the control source dlookup value does not bring back a value i need the default value set to 0(zero).
However It wont show up at all ?