Different ControlSource values for different controls

[tylerg11]

I have a form that is based off of a query. Although, aside from the main data being displayed, I have a small set of 4 text boxes that I want to retrieve data from a query that isn't the one set as the forms's control source. I'm getting the #Name? error. Is it possible to have a few controls in a form that retrieve data from a different data set? Thanks.

[alansidman]

A form may be bound to only one table or query. If you have other controls that you wish to display data for that is from a different table or query, then you will need to have a subform bound to that other object. You can then link the mainform and subform using a parent/child relationship linked on a common field.

Alan

[tylerg11]

A form may be bound to only one table or query. If you have other controls that you wish to display data for that is from a different table or query, then you will need to have a subform bound to that other object. You can then link the mainform and subform using a parent/child relationship linked on a common field.

Alan

I know there can only be one data source for the form. So if I have a control that I want to display data from a dataset other than the form source, I can't just indicate that in the control source for that control? I did something like this:

=[qryCapacityTable]![EquipmentCapacity]

There isn't a relationship between the form data and these seperate controls. i want them to be seperate, but still be able to display other data in these controls. Any other options since they aren't related?