Sending records to a query

[Vwilson42]

This is a new post for this same question. The database that I am working on is set up in a very complicated way to me. The database tracks grant applications and awards. Right now there is a section in the database where one can enter a new record (Well this record is imported from an excel file filled in by the person who wants to update a current application or award for a grant) So when the amount changes on a grant a new record is created but the old information needs to be kept for future references. So this information is keyed into a subform on the same form as the new record. This is quite a bit of information, so I want to know if a button can be created to export this single record to the archive file set up on the same form (same format--different color fields- subform) Basically, I would also like to create a pop up question to say "Do you want to archive this record" the answer would be yes and the record would go to the archive subform (which is our archive query) I hope this makes sense. Thanks!

 

[Jon K]

I have attached a sample database. You can open the form and click on the command button to copy the record from the main form (which is based on the table [tblGrant]) to the subform (which is based on the table [tblArchive]).

The code used is in the On Click event of the command button.
.

 

[Vwilson42]

Sending a record to a query

Thanks!, This is want I need. But the person who set up this database has so many tables and queries with different names that does not follow the tblname format. I am unsure at this point where the record is going. I will work on for now. But thank you for your advise, I think I will be able to use it at some point.