Picking info from one table to place in another

[trackmedic]

Ok,

I want to be able to pick a record from table1 and place it on a form. Once the record from table one is placed on the form, I want to automatically delete that record from the original form. I have a table named inventory. When I open my form called manifest, I can pick the item to enter into the manifest using a combo box. How can I automatically delete that item from the inventory table automatically.

 

[David R]

Try this topic: http://www.access-programmers.co.uk/ubb/Forum4/HTML/001105.html