Result of crosstab query in form

[Ronald]

Hi.

In Access 2007 I'm trying to display the result of a crosstab query in a
(continuous) form.
In the Form_Open event I fill the label Caption and text control
ControlSource with the field names from the query. But when I open the form
the text controls display the #Name? error.

Even when I fill the control sources with the correct field names (selected
from the list) I get the message the name is not in the list...

What is the solution?
Thanks in advance,

Ronald.

 

[Marshall Barton]

In Access 2007 I'm trying to display the result of a crosstab query in a
(continuous) form.
In the Form_Open event I fill the label Caption and text control
ControlSource with the field names from the query. But when I open the form
the text controls display the #Name? error.

Even when I fill the control sources with the correct field names (selected
from the list) I get the message the name is not in the list...

What is this list of field names you used to fill in the
control source properties?

I would use the form's RecordSourceClone's Fields collection
to get the query's field names.