Passing multiple fields to another form

[ou812vh]

I have a form with a subform. The subform gets populated with multiple records at any given time. I need to get the data from a particular field in the subform (which could be one record or more) to copy over to another form. Can somebody point me in the right direction as to how to accomplish this. Thanks in advance for your help

[MMcCarthy]

I have a form with a subform. The subform gets populated with multiple records at any given time. I need to get the data from a particular field in the subform (which could be one record or more) to copy over to another form. Can somebody point me in the right direction as to how to accomplish this. Thanks in advance for your help

You will need to give a lot more information about what you are doing and why.

[ou812vh]

We are using this as a receiving log to log materials in. The main form would show all the trucking info trailer # BOL etc. The subform will show all the products received in that load. We also print out pallet tags for each product received, this is what the new form does. So when we receive a load the operators supply all the info for the trailer and log all products, could be one pallet or several. I need to pull one field out of each of those records and match it with a field in another table to supply the new form with more info in a new recordset. The new form is actually what we are trying to print. Currently I have a qry that runs upon opening the new form that looks at the subform. I thought it would pull out from each record, but it only pulls from the first one. I hope this helps, and thanks for responding.

I have a feeling that instead of using the qry, I am going to have to write a looping sequence to do this.

[MMcCarthy]

This will give you a recordset of all the records in the subform.

Dim rst As DAO.Recordset
 
    Set rst = Me.subformObjectName.Form.RecordsetClone