>Ok got the form working and in fact whole thing works quite well just as do form myform
>
>however one small obstacle i don't believe there will be away around it
>
>i have about 10 variable field names that change every 6 months - i should imagine i am going to have to re-create a new form each time as i don't expect i can change these names programatically - can i??
>
>thanks naomi - first time i have this going.
>
>k

You can, but this would be a bit tricky. You can use a local view or CursorAdapter created on the fly with fixed field names (since they are created as a result of Select command). This way you don't need to change anything.

Alternative solution would be to re-bind (change ControlSources) in run-time.