Copy from Form to Subform

[Joe via AccessMonster.com]

I have a 2003 access database that I am trying to use to log a box and it's
contents for tracking purposes. I have a form that has the Box number and a
subform in that form that will log what is going into the box. I have another
form that I use to search an SQL database for informtion that I need to track.
I am trying to create a button that will copy the results from the search
form into the Sub-form with the box number. Is there a way I can do this?

 

[June7]

You can reference objects on another form. Example:
[Form_form1name].textboxname = [Form_form2name]!textboxname
If you want to replicate the recordset try:
[Form_form1name].RecordSource = [Form_form2name].Recordsource
[Form_form1name].Requery