How to put the query-results into one text field?

[xytras]

HI!
Can Anyone help me with this?
I would like to put query results(one column) into one text field?
Is it possible that results could be in such textfield separated?
Thanks in Advance

 

[xytras]

There is a thread here that will hopefully provide you with some useful information.

Thank's but in fact i'm working on my "sending mail through access" problem and i need to fill textfiield with email addresses from the table with a query

Maybe i'm did not understand thread link

Thank's Again!

 

[xytras]

If I have misunderstood your question then please accept my apologies for reading between the lines and posting the wrong answer. In future if I am not sure what you are asking I will not reply.

If you wish to have a better look at the attached database, and come back with some more questions on how to adapt it to your use I will only be to please to help.

My apoligies. It's my fault. I'm just not good enough. I have question to Your DB. I'm using only one table called contact and single textfield called "to"
Is it possible to put simple Your "Public Function fConList(intBatchNo As Integer, strSerialNo As String)" into some click button that will fill that textfield with the results. How can i use some external attached query without puting sql instruction into code? Or is it neccessary?

Thank's and sorry for being not clear