Access vba 2010.
I'm trying to run this dlookup and if the field value in "Status" = "In Progress" then i need a msgbox to pop up ?
If Nz(DLookup("Status", "qry_StatusOpen", Status = "In Progress"), False) = True Then
MsgBox ("You Can Not Have More than One Open Status")
This is not working ?