Save Subform Fields to Table

[djossh]

Hi,

1. I have a Main form (based on a table) with a Subform.
2. The Subform is based on a Query (Because I want to show the Last recent Record only... Im talking about the Salary)

I want to save the data from the Subform (Salary Field) to my Table, I dont know if VBA will be the best option.. or any suggestions that will give me same results.. thanks...

TABLE FIELDS:
ID*
EMPLOYEE_NOS
NAME
SALARY

MAIN FORM FIELDS:
ID*
EMPLOYEE_NOS
NAME


SUBFORM FIELDS:
EMPLOYEE_NOS
SALARY

 

[Galaxiom]

If the subform is bound to a query it would happen exactly as it happens in any other Access bound form.

The problem is that your subform is using an aggregate (Totals) query and as such is not updateable. You could apply a filter to the subform so that it only showed the latest record.

 

[djossh]

If the subform is bound to a query it would happen exactly as it happens in any other Access bound form.

The problem is that your subform is using an aggregate (Totals) query and as such is not updateable. You could apply a filter to the subform so that it only showed the latest record.

Thank you for your reply.. I'm really a newbie in access, I just want to save that field (Salary) to my table.. Sorry I didn't mention that my query is based on another Table which holds all the data pertaining to salary..Thanks again..