VBA save subform data to Table

[djossh]

Hi Im a newbie to Access, I really need help on this one..
I have a MainTable with Subform
The Subform is based on a Query.
I want to save the data/Fields from subform to my TempTable..

MainTable Fields:
EmployeeNo
Name
Position

TempTable Fields:
ID*
Salary
Allowance

Subform Fields:
EmployeeNO (not Shown on Query results)
Salary
Allowance

I want the fields in my subform to be saved in TempTable.. Thanks in advance

 

[Mihail]

In fact you wish to save the data from the query in a temporary table.
So, design a Make Table query based on the query you already have, then run this new query.

 

[djossh]

In fact you wish to save the data from the query in a temporary table.
So, design a Make Table query based on the query you already have, then run this new query.

Thank you so much... that was helpful...I really appreciate it..Thanks.

 

[djossh]

Why do you need to store the data in two places?

I'm trying to make a database for Employee's Annual Leave Payment..
I need to Get/Extract the current Salary of an employee because I'm calculating his Leave Settlement based on the Current Salary (In case an employee got an Increment during his service)
after extracting those data, I will transfer that data to my Main Table via VBA (Still looking for code).. do you have any suggestions? I'm a newbie to Access. Thanks...