how to copy information from a form to a different table

Hello,

I have a form (the information comes from a query) and i want to copy the information of just one record into a different table.
Do you have any ideas how to do this?

Thanks
Chris

Create an append query based on the query used as a recordsource for your form. Set the criteria to the current record and then run the append query to add the current record to your other table.

lwells

I am also having the same sort of problem, however, as i am not a very experienced user, how would one select the current record from the database, i have been trying to do this for a good few days now, and simply cannot manage to get a single record to transfer to another table.

any extra help would be massively appreciated.

Create a query of the table/query that you are using as the recordsource for your form. Change the query to an Append Query and when prompted designate the table where you want the record to be added.

Select the fields in the query grid that will be the same as in the destination table, if all the fields are the same then you can select all of them.

For the criteria, you would use the form's primary key as the filter. Under the primary key field you will put the criteria/sort for your current record. Should be something like this:

[Forms]![frmFormName]![ID]

Now open your form, navigate and find the record that you want to append to your destination table. Leave the form open and open the query in design view and select datasheet view from the tool bar View menu. You should see just the current record that you want to append. When you run the query the record will be appended to your destination table.

Just use the actual name of your form and primary key field in the criteria.

Make a back up of your tables as a precaution before running the query. That way you have a back up copy just in case. Once your satisfied all is working like you want you can delete the backup copy.

lwells