insert query has no data

[smitty27629]

I wrote an insert query that enters all fields on a form into a table. The form has some fields that are populated by a query and some that are calculations of the other fields. All of the fields that are populated from the query enter fine, but the ones that are calculations are blank.

I read somewhere in this website that if you put an expression in the control source then that control is no longer bound. Does this have something to do with my problem? If so how do I get around it? If this doesn't have to do with my problem, then what am I doing wrong? Thanks.

 

[smitty27629]

Does anyone have any info? Please.

 

[smitty27629]

The form and it's calculated fields are being stored in a table (Totalstab) for later viewing. I created another form that displays Totalstab's data and recalculates the needed fields but when I scroll from record to record the calculated fields do not update. So I figured that I would just store the calculated fields also.

Am I thinking incorrectly? Is there a way to get the form to recalculate the needed fields when you scroll through records? Thanks for your input.