Hi
I am trying to get the code working to lookup all records in [town] in my sub form and then concatenate them into a single field on my main form [Areas]
example
Mainform
Name FrmDailyReport
Field named [Areas ]
combo box named [datedcbo] which looks up dates ( in a table named TblVisits and a field named [VisitDate] (SELECT DISTINCT TblVisits.VisitDate FROM TblVisits ORDER BY TblVisits.[VisitDate]
Subform
Name FrmDailyReport_sub
control is QryDailyReport
the fields are [ID], [Company] [Town] [Visitdate]
so if
record 1 [town] was Glasgow and
Record 2 [town] was Gillingham and
Record 3 [town] was Canterbury
I would expect to see My Mainform [Areas] show Glasgow, Gillingham ,Canterbury
Please can anybody help