Deleting a record on a form.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have created a database that tracks bin location based on item numbers. We
have two types of bin locations. One is called Bulk and is stored in a
table "bulk bins" and a Primary "picking_seq" which is stored in our ERP
system.
I have a linked table "Macloa" to our ERP system which I use as a source on
a combo box for item numbers and Primary bin location. I'm storing the item,
bulk bin and entered date in a third table "bin Assignment"

I have several forms that query the data in differen't ways. The issue is
if I try to delete a record from a form. The form uses a query which is
joined by item number. I'm joining "Macola" and Bin Assignment" in the
query.

How can I allow the user to delete the record from the form? It worked
before the join!
 
Hi,


Is the query you use updateable? I mean, can you use it, as a table, in
the database window, and from it, in data view, delete some records?


Hoping it may help,
Vanderghast, Access MVP
 
Back
Top