I have a query related to a table, and being updated every time i add a record through a form. I want : after i enter a record, i want the data in the query to be stored automatically in another table, with exactly the same fields as the query, without overwriting or deleting any of the previous records..
Can i Do that? Through a macro for example?