Save data from a form to a table (1 Viewer)

[Tom A]

Hello everyone,
I have a list of works to do each week to my machines of my lab. So I created a form from a query (which query is from 4 differents tables) in order to gather all the informations. What I want is to add a button to this form with a VBA code that could save all the informations of this form into a independ table ( an empty table, I would like to have a history).
PS: I don't want to change the datas from my tables, just keep a history in Access (a table).

 

[bob fitz]

Perhaps use an Append query: https://support.office.com/en-us/ar...nd-query-98A5BD66-2190-4243-9638-8EF649CF3596

 

[ontopofmalvern]

This is easy enough to do with an append query as bob suggests, but why do you need to? unless you are deleting data from originating tables this would just duplicate data? You can recall your history anytime using same query.

 

[The_Doc_Man]

From your description, I have to ask if this "four table" source is a system under your control or not, and is it based on Access or something else?

Knowing that might help us better understand what can and cannot happen.