Simple Form Problem, Not sure what to do. Data not going in.

[DraGo150]

This is probably is a very simple problem I’m sure, but not sure how to correct it.

I have a form (frm_Client) with tabs, and one of the tabs has the product the client is purchasing. I have a field that the owner input the weight of the product. Then I have another unbound field that calculates the sales tax from the Control Source (=[Client Cost]*[Product Wieght]*0.07), then I have a field Total Amount that pulls everything together (=[Client Cost]*[Product Wieght]+[SalesTax]).

That is all working fine, the problem is that the Total Amount that is calculated doesn’t go into the table under that column in the database, everything else dose i.e. Product chosen, and product weight, but that is it.

Can anyone tell me what I am doing wrong; I believe that since I am using the Control Source to calculate the fields it is not being pushed to the table. I not sure how else to get the info into the table, is there any V.B. coding or Macro that I should be using instead?

Please help at my wits end.

 

[missinglinq]

I believe that since I am using the Control Source to calculate the fields it is not being pushed to the table. I not sure how else to get the info into the table

Correct! A Control on a Form can only have one Control Source, if it's used to perform a calculation it can't be used to bind the Control to a Field in the underlying Table.

And it shouldn't! Scenarios where calculated fields should be stored are very rare, and this isn't one of those rarities! Instead, the field should simply be re-calculated whenever needed, whether on a form or in a report.

The Missinglinq

Richmond, Virginia

There's ALWAYS more than one way to skin a cat!