Update Query Help

[PicassoB]

Help please, a simple problem that I am struggling with
I have two tables, 1 tblparts and 2 tblproducts

when the product table is added to, I require this to automaticaly update the parts table with only the new records

 

[speakers_86]

I dont exactly understand, but it sounds like you can use the query wizard to find unmatched entries, then just change it to an update query. Good luck.

 

[PicassoB]

thanks for the responce
I can run a unmached query to find the new entry, but then how do you get this to update the other table
I would like the complete operation on a button on the menu

 

[speakers_86]

In the queries design view, you can change the query from a select query to an append query.

To use the button, just create the button, and in the on click event,

docmd.openquery "your query name here",acviewhidden

The acviewhidden part is probably not accurate, but you should be able to figure it out now.