Use value of field to select another field

  • Thread starter Thread starter Steve Stone
  • Start date Start date
S

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?
 
Steve said:
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?
Click to expand...


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])
 
Back
Top