This should be easy, but I'm stumped...

I just want to set the Control Source on one field with the value of a second unbound control.

I have a table with multiple report fields: Rpt1, Rpt2, etc. Instead of showing them all at once, I want to use an unbound list box (RptSelect) to set the Control Source for the field (RptValue) where the actual data is displayed.

The list box contains the field names (Rpt1, Rpt2, etc.). The Control Source for RptValue = [RptSelect]. As you might guess, this returns the string (e.g. "Rpt1") and not the data stored in Rpt1. I've tried all form of quotes, teh Eval() function, and dabbled with DLookup(). Before I dive into VBA, I want to see if there is something I'm missing. This should be so easy...

Neil