Concatenate multiple answers into one field (1 Viewer)

[lmcc007]

Why is using a ControlSource slower than when you use a query? Meaning, I used the Concatenate function using the ControlSource of a text box and I created it using the query (which I put the subform on the form), the ControlSource lags behind the subform. Using ControlSource is easier and I have fewer subforms, but it loads after the other text.

 

[vbaInet]

A query is built for pulling data so it works out the most effecient way of doing so. A control source will simply carry out what you tell it to do. That's the way I see it.

 

[lmcc007]

A query is built for pulling data so it works out the most effecient way of doing so. A control source will simply carry out what you tell it to do. That's the way I see it.

Okay, I was thinking that you can have too many subforms and subforms are just hard to format to look like the other fields. Anyway this form will have six subforms.