Hello
I am new in the area and I try to write some lines but I need your help
I work with 2003 version
Now, I have made a db, the part are:
1 table with 5 columns id, barcodes, pieces, weight, colour
1 same but with no data 1 qry based on 1 tbl of choose and
1 frm with compo frame barcode and pieces, weight, colour
(The only variable is the pieces) winch I have connect the 4 columns with code
The line of compo come from SQL:* and barcode

Let’s say what I enter a barcode
When a write for 2 times the same bc I want to add the number of pieces this time to the previous entry

How I input the data?
In data sheet view with my barcode machine I import my bc automatic
All the line is preset by the tbl1 who include the data
I have set in options in move after enter the cursor goes to the next record
So I just push the button of my bc machine
Describe the barcode
The bc has one arrow in the end .If I click in the arrow appears the
Others columns, pieces weight and color
I connect all with a code from bor code control elements
The code I use is:
>
> > Private Sub BARCODE_AfterUpdate ()
> > Me. pieces = Me.BARCODE.Column (1)
> > Me. weight = Me.BARCODE.Column (2)
> > Me.colour = Me.BARCODE.Column (3)
> > End Sub

What’s happen now?
When I enter a same bc the line appears as the times I input the same bc
For different its wok normal
What I want now?
If I input the same bc for multiple times the number of
Pieces just add

Please can you help me?

I think that what you really want to do is load the records from the barcode machine into a recordset and loop through it, each time checking the table that you are inserting into for the bar code #. If you find it, then you update that record such as;

'rs as recordset you are inserting into or updating

'rst as recordset from barcode machine
rs("Pieces") = rs("Pieces") + rst("Pieces")
rs.update

I know this is a very short code snipet, but I think it should give you an ideal of how to handle this.

Bill