I have a filtered query, called query1 bound to Table A that returned dynamic rows of text data in a field(field1).
I have a form, called form A bound to Table B where a vba code will perform Dlookup to copy the data from field1 to a text box in form A when the form is activated.
Problem is, Dlookup is only return the first row of data from field1.
Is there a way in vba to lookup all the rows from the filtered query then combined all the data of each row and seperated by a comma into the text box in form A?
Thanks in advance.