Using a formula in a table

[mgbeye]

I am working with a form and a table. I have the form set up this way:
-->when you enter an SAP code it looks up the description
for the item as well as its cost.

-->When you enter the palletizer count and the pallet count it automatically calculates the difference to be put in a variance field

-->the variance field is multiplied by the cost and put into the Cost field.

how do I make my table update these fields when changes are made in the table itself without the form?

HELP!

Thanks!

 

[LonnieJohnson]

If there is a way to do this at the table level, I would like to know myself. Your only choice may be to do this at the query level.

B-) ljprodev@yahoo.com
ProDev
MS Access Applications

 

[MichaelRed]

Use a form. Bind the controls on the form to the table. for the 'required entries', code their after update events to call a sub (Sub Calc?). In sub Calc, check for all required entries on the form. If they are all present, do your calcs and assign the results to the text boxes on the form. As you move through the proces and go the next item, the calcs will be entered into the record. You will need to be sure that for each item you enter on the form you are either adding a new record or editing an existing one - and controlling that process.



MichaelRed
redmsp@erols.com

There is never time to do it right but there is always time to do it over