Data Shows on Form but Does Not Write to Table

[Hillary]

I have a form based off a query. There are 3 tables in the query. 2 tables are linked to the database from our ERP Database and the third table resides solely within the database.

I am pulling data from each of the 2 linked tables into the third table and also adding data to the third table. I am not writing to either of the first 2 tables.

Tables (*Primary Key)
Part Location Tag Entry
ID*----->Part ID*-------->Part ID
Warehouse*----->Warehouse
Location*-------->Location
Quantity Count Quantity
Location Quantity
Tag ID*

The only data I want to populate is Count Quantity. When I enter the Count Quantity all the data populates the form. The problem is when I go to the table Tag Entry, Location Quantity is blank. Everything else is okay. I have the Control Source set to =[Quantity]?

How can I get [Location].[Quantity] to write to [Tag Entry].[Location Quantity]

Thanks for your help.




Hillary

 

[ZmrAbdulla]

Hi,
Check this thread181-540763

ZmrAbdulla