But if the record already exists I want the record to be deleted from the datasheet. How can I accomplish this?
If Me.NewRecord = True Then If (Not IsNull(DLookup("[UniqueID]", "tblScheduleRecords", "[UniqueID] ='" & Me!txtUniqueID & "'"))) Then MsgBox "This client has already been scheduled for this Group, Schedule Date & Time." Cancel = True End If End If
Experts Exchange (EE) has become my company's go-to resource to get answers. I've used EE to make decisions, solve problems and even save customers. OutagesIO has been a challenging project and... Keep reading >>