control source via combo

[luvbite38]

Hi Guys,


Happy New Year to Y'all


I hope this would be the simplest Q for most of you.

I have a combobox containing the "Field Names" of a table called "Main"
Also, I have a report called xyz which only has one field.

All I want, whatever field name user selects in the combo, report displays the results of selected field name only.

example

Main Table has three fields (Fie1, Fie2 and Fie3)
The combo box lists the names of all three fields (Fie1 to Fie3)
Report has a textbox in the detailed section.
I want user to select the field name from combo click button to generate the report (lets say if user selected Fie2)
and want textbox to list all the records of Fie2

Hope it makes sense?

i tried [Forms]![Fm1]! [cm1] but it is listing the field names not the values in the field...

pls help

Regards,
Luv

 

[luvbite38]

someone pls help????

it has been 7 days since I have been trying to find any solution for this...:banghead: