Concatenate multiple answers into one field

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.
 
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.
 
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.
 

Users who are viewing this thread

Back
Top Bottom