Microsoft Access Contact Template. Open and New Function

[shani908]

Hello

I am trying to recreate Contacts Template from scratch, to learn and improve my understanding of the system.

When I open the Contact List , in Contacts Template, It shows the following code:

=IIf(IsNull([ID]),"(New)","Open")

Can somebody please explain what is this "(New)", ("Open") ? Is it some internal existing functions ?

I also understand there is some associate Macro with click event, I have looked into it but couldn't figure out any utilization of this "Open" and "New" Function or string.

Thanks

[Micron]

If you had selected what looks like a textbox instead of the detail section of the form I'd have a better notion because the property sheet for the control would be in your pic instead. To me it looks like a calculated textbox where the expression evaluates to "(New)" if there is no ID value. If there is, it evaluates to "Open". One of those values would then appear in the control when in form view.