Update all records in a continuous form

[deepcec9]

Re your table, IN is a reserved word - even with using the square brackets it may still result in unexpected results

can you please provide me the list of reserved words in access.

 

[sneuberg]

https://support.microsoft.com/en-us/kb/286335

 

[CJ_London]

Hi, please correct me if im wrong
doing an inventory management, created two tables in and out

This should be one table with a field to indicate whether the transaction is in or out.

 

[sneuberg]

I don't understand the point of these intermediary tables or table. Consider a checkout scanner in a store. When an item is scanned wouldn't that reduce the quantity in the inventory table directly so that the inventory is current. I could imagine this sort of in/out table if the scanners weren't wired to the computer that had the inventory but instead stored the information on a thumb drive that was later hand carried to the inventory computer. Is that the idea here?