I have a form that has a sub-form. The sub-forms record source is a query and is displayed as a datasheet. But what I'm trying to do is populate a field on the main form with data from the query in the subform. But I need to populate the information as, for example, "Steve, Bill, David". In other words, the results of the query separated with a comma and a space.
So if the query looks like this:
Populate the field on the main form with "Steve, Bill, David"