Append form results to new table

jak26

Board Regular
Joined
Dec 4, 2007
Messages
53
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
 

Some videos you may like

Excel Facts

Can you AutoAverage in Excel?
There is a drop-down next to the AutoSum symbol. Open the drop-down to choose AVERAGE, COUNT, MAX, or MIN

bobsan42

Well-known Member
Joined
Jul 14, 2010
Messages
1,343
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
 
Last edited:

bobsan42

Well-known Member
Joined
Jul 14, 2010
Messages
1,343
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.
 

Watch MrExcel Video

Forum statistics

Threads
1,109,087
Messages
5,526,772
Members
409,720
Latest member
Antwain

This Week's Hot Topics

Top