I'm new so please don't get too technical or yell for non-clean code.
I have an unbounded text box that I'm trying (through Expression Builder) to get to display the date of the last note entered for a customer. It works great unless there has never been a note for the customer. If that is the case, it just bypasses that customer so I don't see they have an open ticket.
My code for the text box is-
=IIF(IsNull(DMax("NoteDate","Notes","[CustomerID] = Form![CustID] ")),"No Notes",DMax("NoteDate","Notes","[CustomerID] = Form![CustID] "))
"No Notes" is what I'm trying to get to display if the Notes tables doesn't have an entry for the customer.
Thanks.