I've made a form which has a field which calculates the values of previously entered data.
The data should then be saved to a table called Form Results.
When the field(Combo37) is a combo box, and the control source is the Forms Results table, the data saves fine(the row source is the formula).
The drawback being the user must manually click on the combo box arrow to get the data to appear in the drop down and then it will save.
Anytime i make the field on the form a list box, the formula works, but the data does not save to the table .

Anysuggeations on how to easily solve saving the field in this form to a table?

Table=Form Results
Field in Form = Combo37 for reference.

You may need to re-think your design. It is almost always a bad idea to save the results of a calculation in your table. This breaks "Rules of Relational Database Normalization". You should always recalculate the result "on demand" and "on the fly" when needed. This is the only way you can be assured that the result is always correct. If you store the result, this result becomes "Static" and any changes made to any of the data used to calculate the original result will cause this stored result to be incorrect. The result of your calculation should always be "Dynamic" if anyway possible.

HTH
RDH

[This message has been edited by R. Hicks (edited 08-08-2001).]

i agree, unfortunately, the company added a bunch of features at the last secind and it would have involved a ton of restructuring to the database...so i'm sorta stuck now.