combine the same field in multiple records into a string 1

[Senjen]

i want to combine the "name" field from all records with the same "child id" into a string to insert into a text field. the fields are located in the same qry result "XQryTal". Any help would be greatly appreciated. i have checked knowledebase, help, and threads for a like question for 2 days.

 

[JerryDennison]

You'll have to build the recordset and then iterate through it building your string. Depending on your version of Access the following may have to be modified slightly. I haven't checked for syntax(no guarantees there) but it should give you the picutre.

...
Dim dbs As Database
Dim rst As Recordset
Dim strSQL As String
Dim strString as String

Set dbs = CurrentDB
strSQL = "SELECT * FROM XQryTal WHERE [name] = 'ChildID'"
Set rst = dbs.OpenRecordSet(strSQL)

rst.MoveFirst

While Not EOF
With rst
strString = strString & " " & .name
.MoveNext
End With
Wend