Append Single Record on click of button

[franklinbukoski]

I want to append a single record from a query in one database to a table in
another database, when I click on a button I label Complete. This button is
part of the source table the query runs from.

The source query is Completed Awards, it shows me all records in a table
where an award has been checked as complete. The problem is I need a
historical record of all awards for each company in our organization, but we
have personnel turnover every three years, and there is a finite key (the
billet they are assigned against). So, one person may have multiple same
awards, but different dates, and then when they leave, their billet gets
assigned to someone else, so my current records won't show me where they
worked or their name, just their SSN and the award they received. I probably
haven't articulated the dilema correctly, but any assistance would be greatly
appreciated.

 

[[MVP] S.Clark]

Create a form.
Add a button.
In the code behind the button, run the query.

Private Sub cmdComplete_Click()

docmd.openquery "MyQueryThatDoesWhatINeed"

End Sub