Use value of field to select another field

[Steve Stone]

I have inherited a database with multiple fields that identify selections.

Field1 = session 1
Field2 = Session 2
Field3 = session 3

The values for each of these fields can be A,B,C, or D.

I have another field named SELECTFIELD that identifies which of the above
fields to print on the report. The value of this field is

Field1, Field2, field3, ...

How do I use the value of selectfield to print the correct session field?

 

[Marshall Barton]

I have inherited a database with multiple fields that identify selections.

Field1 = session 1
Field2 = Session 2
Field3 = session 3

The values for each of these fields can be A,B,C, or D.

I have another field named SELECTFIELD that identifies which of the above
fields to print on the report. The value of this field is

Field1, Field2, field3, ...

How do I use the value of selectfield to print the correct session field?

This is knd of wierd, but I think it will work for this
problem. Set the text box to display the selected field to
use an expression like:

=Eval("Reports!yourreport." & [SELECTFIELD])