essentially that vb statement does the same thing that my switch statements do. I was wondering if there is a way to automate that in vb, so instead of a bunch of case statements, i could just add a certain number of years to a field name

Essentially... this is what i'm looking for:
1. substring the year out of the delivery date
2. add the inputted parameter amount (1-5) to the year value
3. take this year value and concat it into the string "Act [yearvalue] EUR"
4. Retrieve the field from the table that is titled "Act [yearvalue] EUR"


Essentially a 4 step function. But i don't know visual basic so i dont know the specific way of coding it.