Create a MACROS that UPDATES a column from another Table?? Microsoft Access

Microsoft Access: I have a main table, and I want to create a macros so when the user clicks on a button, it pulls data from a particular field from another table and update

www.tutcity.com