VBA access macro or function

[Ran Bieganiec]

I have a table with 3 column that contain a YES\NO. Upon ticking one of the 3 boxes I want to copy the content of the row into a different table and I can't find the right code.
What is more recommended a function or a Macro?