Hi all, I am facing the following problem: in my program I have several tables and I need to copy the data from one table to another. What I need to do is primary to filter the data from one of the tables (which I have already done using form and query) and what I need is to save those records to another table at once. Lets say I have filtered 3 columns (A, B and C) from table 1, that gives me as a result of 10 rows of records in the form. I need a button that on click will save those records to tabled 2 in columns A1, B1, C1.
What I was told was to use "Create a Record In" macro action but I think there is now such action, or at least my access does not have it.
Can anyone help me?
What I was told was to use "Create a Record In" macro action but I think there is now such action, or at least my access does not have it.
Can anyone help me?