Another expert helped me with a situation where I need to alert a user if a name already exists in the database. But not I need to also provide them the existing record's date of birth from the DOB field.
Here is my before update code so far. How can I change it to show the records DOB?
If DCount("*", "Member Table", "MemberFirstName = '" & Me.txtMemberFirstName & "' AND MemberLastName = '" & Me.txtMemberLastName & "'") > 0 Then
MsgBox "There is already a member in the database with this name.", vbOKOnly