Change field names in VBA

[Razor]

Hi,

I have a form with a listbox and a button.

The button runs a dozen reports in sequence using a filter
from the listbox.

I'd like to have my queries/code run on a different field
at the user's discretion. I can implement the user's
choice through a radio button.

I've so far been changing field names in the table design
view itself but this is cloogy.

Is there a programmatic way of swapping my table's field
names (without going into design view) purely from the
form interface?

Thanks,

Razor