Appending current record to new table using a query

[willmafingerdo]

Hello,
I would like to make it so if the user clicks on a button it will run an append query and only append the data for the current record to the new table. I have it currently so it will add all records and it works, i am just not sure how to get it to limit to only the current record.


Thanks,
Will

[pbaldy]

Add a criteria to your append query that limits it to the key field displayed on the form.

[willmafingerdo]

I understand what your saying pdaldy, but i don't know how to do it. could you provide some explanation or a link to the info?

[pbaldy]

In the criteria:

Forms!FormName.TextboxName

using the two appropriate names.

[willmafingerdo]

In the criteria:

Forms!FormName.TextboxName

using the two appropriate names.

Sorry i had to work on a different project there for a while... I almost have this working... If i click on view query it will display the data i am trying to capture, but when i run it i get that the data cant be appended error. I even copied the original table and made it a new tableso all the data types ect all match. I have attached some screen shots if that would help.

[pbaldy]

Are there required fields that your query isn't populating? Is the data being appended in the correct format, data type, etc? Is it violating a validation rule set in the table?

[willmafingerdo]

Ok, so i tried switching it to a "Make Table" query, ran it and it created the table and exported the data. Now i switched it back to an append query and it seems to be working now... any idea on what i was/am doing wrong?

[willmafingerdo]

Yes i copied the source table and renamed it with structure only so the new table should be a mirror of the source table right?

[pbaldy]

Yes, it should be. Working okay now?