How Is this possible?
The scenario is this. I have the following:


I want to makes multiple changes on multiple records on the Inventory table. What I have done is created a form that has a datasheet view and represents the UPDATES table.

In the bottom is the Datasheet view of the INVENTORY table.

After several headaches and "google" searches I don't have an idea of what I'm doing wrong. I have created an updates query based on the changes of the "UPDATES table" datasheet but it only updates the INVENTORY record if the record selector on the "UPDATES table" is on the right record to be updated.

All help is very appreciated!!!!