Copy data from subform to table

[EHQG]

I am looking to copy records that I have edited in a sub form and put them into a new table I have created.
The sub form shows me all of my active jobs for a specific person and it has two fields on it so I can add details beside the records. What I want to do is when i click save, I want only the records that have been edited to save into a table.
Would this be possible? What would I need to do to get this to work?


If you need anymore info let me know.
Many Thanks

[ranman256]

the exact query you use to show the subform data can be used in an append query.
qsSubForm = select * from table where [id]=forms!myForm!txtID

then use it in an append query to your other table
qaAddSubFormData =
insert into Newtabl from qsSubForm

so all you need do is run: qaAddSubFormData

[ssanfu]

Isn't the subform bound to a table???

[EHQG]

Isn't the subform bound to a table???

Apologies if i haven't been too clear in my post. The subform is bound to a query that links 2 tables. (The subform is a datasheet). I have a combobox that allows me to filter the subform by person. So by doing this each person can go into the subform, change it to only show their jobs and add their predicted hours and comments beside some jobs. Once they have done this they will hit Save and close which will do just that but will also copy over the records that had data entered into them to an existing table . I hope this makes sense,

[orange]

EHQG,

Clarity is key to getting a focused response.
It might be more efficient if you could post a copy of your database along with specifics and examples of what you are trying to accomplish. Clearly describe the data you are adding and what you expect as output/result.

Good luck.