Copy and pasting related fields in a new table (Acess VBA)

I am very new to Access VBA. I am creating a form with a textbox and when the user enters the information then it will search it in table XYZ within access and once it finds the results then it will copy five related fields for couple of records from this table and paste it on a separate access table ABC. I am not sure how to exactly code this in the vb editor. Any suggestions would be very helpful. Thank You.

IS