i am beginner in MS Access i want to save entries on form(named: MDF) through a save button if form field "Primary Cable" (indexed with other field Primary Cable Pair) have duplicate value then on pressing save button a custom massage e.g "primary cable have already been used" should be appeared instead of system massage.
i need axact vb code for "on Click Event" of save button
amme