This seems a very unusual approach! What is your table structure? What
information are you copying (?) from the subform to the mainform's
table? I worry that you may be storing data redudantly!

To directly answer your question - no it cannot; in fact typically a
mainform will have *one* record linked to *many* records on each
Subform, so "the record" on the subform is not usually meaningful
(which one?). I wonder if you should perhaps be using Listboxes or
Combo Boxes instead of subforms; these can be bound to a table value.

                 John W. Vinson[MVP]