Storing SQL results via Recordset in a text box

[andatabase]

Hello,
I am currently building a form where I need to store the results of an SQL into a text box.
The results will be a one field query, where it will display the Customer names. The bit I am stuck on is not the SQL, but to go through the results and assigning it to a textbox.
Will I need to do a for loop and assign to an array? If so, I will need some assistance with the coding. Thanks in advance!

 

[MajP]

Why not use a listbox? You can bind the recordset directly. If not you need to loop and create a concatenated string.

Queires on continous forms ?

Hi Guys - having a a minor moment .. ok I have a continous form and on each "record" is a country Germany/France/ Ireland/USA states .50 of them ...) and i select one from a drop down list (no problem) OK I want to have a list (showing on the record /form) of all the other records...

www.access-programmers.co.uk

 

[andatabase]

Listbox won't help as this needs to be for info only. This text box will display the customers for selected records:
"Selection includes: Customer A, Customer B"

Thanks for your suggestion, mind.

I will need some help on the for loop and concat string, if that is the case.

 

[MajP]

I will need some help on the for loop and concat string, if that is the case

That referenced thread shows 2 generic functions or a way to roll your own as I prefer.

 

[andatabase]

Woops! Sorry, just read the header. I will have a look.

thanks

 

[MajP]

If your main form is not Continuous then you can add a subform or subreport to show this. That is the easiest method. You can set the properties of the subform to be "read only" and a subreport is display only anyways. Only need to concatenate if in continuous view like the thread.

 

[andatabase]

Thanks @MajP

 

[Isaac]

Maybe this should be moved to VBA forum, not Macros