Calculations

[Brenda]

I have just created a form, or the start of a form.

I have about two dozen fields that data will be entered into.

I now need to add fields that will make calculations based on some of the data that is entered into this form.

Question: Do I add these new fields that will make the calculation on the FORM, or do I need to do that in a REPORT? (Or something totally different?)

Can the FORM make calculations based on user input?

TIA
~Brenda

 

[lipin]

The form can do calculations, put the calculation in the OnExit event of the second control of the 2 you are adding(or whatever) but this will only work if you have the tab order set so that a user can't skip the textboxes on the form. But...

It is probably better a practice to let a query do your calculations and then have the query feed the information into the report.

 

[Mile-O]

If you use textboxes to do calculations on your forms you can use the form's OnCurrent() event and put a line of code in there that updates all the time

The code is simply:

Me.Refresh

If you are using numerical values in textboxes then it may be useful to refer to them using the Val() function in such a way:

=Val([Text0]) + Val([Text1])

 

[Brenda]

Thank you

Thank you very much. Let me give it a try!

~Brenda