Select a record and populate another table

[Lee T.]

I have a form with 4 sub forms. I would like to select a
record on one of the sub form (they are continues forms)
and then have a command button that would take the data
from that record which is based on a query and populate
another table. I am not sure where to start or if this
can be done.

tia

Lee T.