Append form results to new table

[jak26]

Hi

Hopefully someone can help

I have a form that shows the results of a query. The users can then edit some of the query data however I would then like the data to be written to a new table.

I thought I would be able to do it easily but it seems I have over estimated my ability

Cheers
Jeff

 

[bobsan42]

oops sorry - it's Access (and i haven't used it for a while)

But as far as i remember it's not necessary to take the data from the form but directly use the query

 

[bobsan42]

OK i remebered a bit more.
The Queries may be of different types.
Select Query, Make Table Query, Add Record Q., ......
u just need a second "Twin" query, just must be of type "Make table" and with the push of a button u run it .
Sorry, i can't be more specific but it's been quite a while and old my code is not handy right now.