the actual database uses different names for each field.
In that case you'd create a two-dimensional array to store the values. One dimension is the control name, and the other dimension is the control value. Then you'd loop through all the controls on the form, doing something like:



Code:
Dim ctl as control

For Each ctl in me.controls
    ... code to store value in the array or retrieve value from the array
Next
If you need to skip some controls, you can do that with Select Case and checking the control name.

So that's how you'd do it with a loop if you needed to.