Bound Control On A Form Problem - Office 2003
 

I have an Excel 2003 application that uses a userform to input data. All of
the controls on the form have default value zero and are bound controls,
bound to a single row on worksheet A. When the user is finished coding the
data (into text boxes and combo boxes), the user clicks on a "Save" command
button which "saves" the record, i.e., saves the data from the single row on
worksheet A to a worksheet B (where there are thousands or records). The
problem is - immediately after clicking on the Save command button a number
of the controls have their cpded value revert to the default value 0. Has
anyone observed this problem and what is the solution?