I have 2 tables

Table 1 is bought items

Item # Barcode #
---------------------------------
Glove 2458
Biscuit 321
Glass sdf254

Table 2 is sold items

Item # Barcode #
---------------------------------
Glove 2458

When I scan an items barcode # as sold into table 2, I would like Access to delete "automatically" that item from table 1. Is that possible?

Thx
Omer

I wouldn't actually delete the record.. add a field in table 1 called "deleted" and then update it.

When the barcode is scanned the barcode number will be read into access... you can then use an update query to mark the record as deleted.

Hi,

Can you clarify how to "you can then use an update query to mark the record as deleted."

Is it possible to give me a step by step on how to create an update qry fo rthe simple example above. ............ Everything I have learned in access is self-taught or through this forum.

OK I added a field in table 1 "Deleted"

Then I went in qry (Created from table 1)............. Changed the qry type to update qry.............. Its runs but who knows what it is updating?

Can I post and you can look?

Thx

omer123456,

I think the other thread is what you need here. It will fix both problems.

OK I hope so ............. I hope the file attached properly