Result of crosstab query in form

R

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

Marshall Barton

Ronald said:
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...
Click to expand...


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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Append Crosstab Query to Existing Table 0
Display result of crosstab query in form 1
Dynamic Naming of Form Button 3
Help creating a search form in Access XP 0
DLookup in Continuous form 0
Template with fields and premade texts.. 0
Creating a Chart on form from selected data in query. 0
MS365 WORD: How to Create Macro Button to CLEAR ALL fields in fill-in form 1

Top