Hi Jason, I understand your reasoning, however in this instance I want to be able to create an item from the decor sheet data. I have items in the items table that are one off items and items that I want to be able to generate from the decor sheet without having to re enter all that information. Once the information is received I want to be able to manually adjust it so the item entry needs to be autonomous, however being able to initially draw the data across is a big time saver. I've done it before using a 2 step entry process with an insert page then an update page that uses the ID inserted on the insert page to create the recordset that populates the update fields on the update page, however it would be nice if it could be achieved on the same page dynamically.
