Add form Data to Table

[coolcatkelso]

Hiya,

I know this is simple but forgot how to call it in

I have a form and a subform on the main Page, The main form contains th customers details, name address etc and a field called AccountStatus

The subform has Workorder details, Startdate, material total, labour total, total payments etc

In the main form on the field Account Status - Have this as the source code - =[Workorders by Customer Subform].[Form]![Text55]

Text55 is a calculation within the Query - Materials Total+Labour Total-Total Payment which is then summed and displayed in the Main Form field (Account Status)

Appears to be working perfectly, but The data isn't stored within the Customer Table (Account Status)

How do I get it to store this data in the table so I can call in future?
________
Marijuana Vaporizer

 

[missinglinq]

In order for the textbox value to be stored in a table, the table field has to be the Control Source for the textbox, but you have your calculation as the Control Source! Obviously you can't have both, and in point of fact, you shouldn't!

Although there are a few exceptions to the rule, Calculated fields should not be stored in a table, but rather simply re-calculated when needed, as when creating reports or when appearing in other forms.

In other words, your current setup is the correct one!

 

[coolcatkelso]

Thanks for you reply

I see your point.

What i need to achieve tho, is I have another form that popsup a reminder for unpaid accounts.. Current setup is to have a yes/no box and have that as the critia, but I would rather have it search unpaid accounts based on the Account Status.. So if account balance is ?0.00 then it won't be flagged.. Having the user tick a yes or no box could be more trouble than its worth as they could forget to tick it.

So is this still the best option, the way its currently Working?
________
Wendie 99