Hi everyone,

Thanks for any help in advance. I have a subform containing to items, unique is (join to main form), and destination name.

I am trying to get the contents of this subform, ie

HGJ
HGF
HGF
HGF

into a recordset, i can get all the data from the table the subform is based on, but not the items only joined by the unique id.

Does anyone have any idea how to do this,

thanks

Chris

IN code...

SELECT [items], [destination name] FROM tblWhatever WHERE [unique id] = " & Forms![main form]![unique id control name] & ";"

Or add the same criteria in the Query Builder for a saved Query...

Forms![main form]![unique id control name]

chris