Update table from a subform

anchamal

Registered User.
Local time
Today, 10:33
Joined
Mar 7, 2010
Messages
57
Trying to update table "items" bases on the contents of table "temporaryitems"
what i need to do i to go and check if first record on my subform called "temporaryitemsqrysub1" already exists then go and update in table "items" but if does not then go and add it in table "items", then got to second record on the subform and check again so on till the end.

i'm attaching a sample of my database which i can not get it to work

using access 2016

thanks
 

Attachments

Could you show a printscreen of what you mean, (what the result should be).
 
if table temporaryitems has records that are not already in items table then add them, else go and update them
that's what i need
 

Users who are viewing this thread

Back
Top Bottom