Need Help selecting a single record from a form and adding to another table

[pc95221]

I have 2 tables Change_History & Response_Number

I have a form FRM_AddNewRecord which takes the fields from Change_History and creates a new record, I need a query that will also add it to the Response_Number table as well.

The fields are Response_Number, Caller_Experience, Business_Owner and Last_updated

What i have so far is an append query like this;
Field:Response_Number
Table:Response_Number
Sort:
Append To:Response_Number
Criteria:[Forms]![FRM_AddNewRecord]![Response_number]

can anyone help me with this as when the query runs it appends 0 records, which obviously isnt what it's meant to do

 

[pc95221]

I should mention I'm rather new at access so answers as simple as possible please to match my intelligence