How to load a field control source from a query or form field valu

M

Marco

Hi.

I have a problem here. I have a report that has no fixed fiels recordsource.

This is define in a form in where my users do their options.

So, imagine that my user choose OptionA and Value3 on another field.

This means that my field XPTO in report should load column AA from query.

If my user choose OptionB and Value2, means that the report field XPTO must
loaf column BB from query.

I have a matrix query in where I have the column names that must be loaded.
My problem is that instead of loading the values it's appering the columns
names that it should be load the values.

Imagine:

my query result says that it should load values from
"126_qry_YTD_YTG_Fcsts.Mes5" column

but istead of that the field value result is the
"126_qry_YTD_YTG_Fcsts.Mes5" in text.


Please help me out here to solve this.

Regards,
Marco
 

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

help to create variables record sources. 4
Using field in a form to set parameters for a query 3
Changing the Control Source 4
Change Text Field value from Button Control 1
#Name? error in field values when subfrm linked to frm 0
Use a form control value to filter query only if form is loaded. 3
How to chosse a column based on a criteria? 8
How to select fields appear on report from multiple tables 2

Top