Hi all, I have 2 linked tables that I am pulling information from; PRODUCT and USER. I have created a query that pulls the user information from the USER table, and the product information that the user has previously used is displayed in a subForm using a subQuery. I would like to be able to create an update query that can be added to the subForm that creates a new record in a different table that adds the user, product info and date/time the record was added. Any suggestions would be helpful. Thank you in advance.