I've got a calculated value on a form that I want to save into a table. Other than writing VB Code to do SQL commands, is there a direct way to do it in the form?

Thanks in advance

If the form is bound, then you just do the calculation on the Before Insert and Before Update event of the form. It is generally not a good idea to store calculated values, however, there are times when it is beneficial, as when the variables may change and you want the value actually charged a customer using the then current value.

That being said, do something like this:

Dim iQuantity As Integer
Dim lPrice, lTotal As Long

iQuantity = Me.Quantity
lPrice = Me.Price

lTotal = iQuantity * lPrice

Me.Total = lTotal

Did that work?


mmcdonal

Thanks mmcdonal

I don't have a chance to try it right now, but I will in a few days. From your sample code, it looks like I can update data in the table without doing SQL, just by referring to the bound table as "Me."? I'm used to doing databases through SQL commands only using a different programming language, so I'm trying to figure out how best to do it in the integrated environment.