Popup if serialnumber already in table.

[zapperen]

I have registration form, that you write serial number and so on.
But i will prevent the user from registrate same thing twice. So if the serialnumber already in the table, then a popup message will tell them so?
How is this possible? Use a invisible button that activate when they pusb enter.
Dlookup?
Help me :)

[MMcCarthy]

I have registration form, that you write serial number and so on.
But i will prevent the user from registrate same thing twice. So if the serialnumber already in the table, then a popup message will tell them so?
How is this possible? Use a invisible button that activate when they pusb enter.
Dlookup?
Help me :)

Go to the serialnumber field in the table. Set the Indexed property to Yes (No Duplicates). This will not allow the user to enter the same serial number twice.

Mary

[zapperen]

Private Sub SjekkRekl_Click()
 
Dim db As Database
    Dim swaptable As DAO.Recordset
 
   Set db = CurrentDb()
 
     Set swaptable = db.OpenRecordset("SWAPkeep", dbOpenDynaset, dbSeeChanges)
 
 
    swaptable.FindFirst "Serienr = '" & frmSerienr & "'"
 
 
    If swaptable.Fields("Serienr") = frmSerienr Then
        MsgBox ("This serialnumber is already in the database.")
        Else
            DoCmd.GoToControl "status"
        Exit Sub
    End If
    End Sub

Just for a little control message. In some few cases we have to use the same serialnumber twice.
But thanks for the answer :)

[MMcCarthy]

I'm glad you got it working.

Mary