This seems simple but I can't figure it out. I would to use the value from Field1 to reference another field on the form.
FieldA FieldB FieldC
Field1 will be a combo box where you can select one of the fields above
So lets say the value for Field1 is "FieldB"
I want to basically set me.field2 = me.(value of field1 which is "FieldB")
I hope that makes sense??