Record Exist? Problem

[crampz]

The Following code i am using at the moment is to ADD (only) to a database.

        Dim connection As New OleDbConnection("PROVIDER=Microsoft.Jet.OLEDB.4.0;Data Source = ..\db1.mdb")
        Dim command As New OleDbCommand("INSERT INTO Table1 (Barcode, Box, Description, Whos) VALUES (@Barcode, @Box, @Description,@Whos)", connection)
        command.Parameters.AddWithValue("@Barcode", txtBarcode.Text)
        command.Parameters.AddWithValue("@Box", txtBox.Text)
        command.Parameters.AddWithValue("@Description", rttDetail.Text)
        command.Parameters.AddWithValue("@Whos", txtWho.Text)
        connection.Open()
        command.ExecuteNonQuery()
        connection.Close()

But what i need before it adds it to the database is too check the Barcode column to see if what is typed in the txtbarcode.text textbox matches anything in the barcode column in the DB. if it does a messagebox appears to tell them if not carry on.

any help is helpful

thanks

[jmcilhinney]

Don't post the same question in multiple forums.

http://www.vbforums.com/showthread.php?t=524583