prevent adding records more than one time

[accesslover]

hello


i have this sample database
How i can make sure after pressing save BTN the code will start form the beginning each time I press save BTN
to make sure the conditions will be applied

1234.accdb

[June7]

Options:

1. set sage and sname as compound unique index in table design and duplicate pairs will not be allowed

2. code checks for existing record and prevents saving data if already exists

If DCount("", "tblTest", "sname='" & Me.sname & "' AND sage=" & Me.sage) > 0 Then
MsgBox "Record already exists."
Else


Normally, age is not saved, date of birth is saved and age is calculated.