G GD Nov 17, 2008 #1 Can I set up a query that allows the user to alter the results, without it altering the source data in the table?
Can I set up a query that allows the user to alter the results, without it altering the source data in the table?
M Michel Walsh Nov 17, 2008 #2 Make a temporary table from your query and present that table. Another alternative would be to use a disconnected recordset, and to not synchronize it back, but that is not supported by DAO. Vanderghast, Access MVP
Make a temporary table from your query and present that table. Another alternative would be to use a disconnected recordset, and to not synchronize it back, but that is not supported by DAO. Vanderghast, Access MVP