J
Jackson via AccessMonster.com
Hi,
I've got a report that I want to have say 5 floating fields in, say Field1,
Field2 etc
The query the report is based on might have say 10 Fields. What I want to do
is have a form with 5 combo boxes, all based on 10 available fields in the
query and then the user can change what fields appear where for the report.
The problem is I can't work out how to make the control source of the report
field equal to the combo box value.
As an example, I made the field names in a table with records bound to the
control box such that it had qryTest.F1, qryTest.F2 etc. If I made this combo
box the source of the first report field, it simply showed the text and not
listed the actual query results. Does anyone know how I could accomplish this?
Any help most appreciated.
I've got a report that I want to have say 5 floating fields in, say Field1,
Field2 etc
The query the report is based on might have say 10 Fields. What I want to do
is have a form with 5 combo boxes, all based on 10 available fields in the
query and then the user can change what fields appear where for the report.
The problem is I can't work out how to make the control source of the report
field equal to the combo box value.
As an example, I made the field names in a table with records bound to the
control box such that it had qryTest.F1, qryTest.F2 etc. If I made this combo
box the source of the first report field, it simply showed the text and not
listed the actual query results. Does anyone know how I could accomplish this?
Any help most appreciated.