Performing calculations in the form.

[mulefeathers]

I have a form that I want to perform some simply math in the form. I could do it a query but this is an unbound form that a user will be using.



I have six fields on a form. 5 text box and 1 combo box. The combo box populates 2 of the text box. The user will input a quantity in another text box. So I have txtqty and txtpackagecost.

I want to multiply the 2 togeather and have the answer placed in txttotal.

I used this code so that when I tab into the field I would get the result however I am only returning $0.00

Private Sub txttotal_GotFocus()
Dim txtqty As Integer
Dim txtpackagecost As Integer
txttotal = txtqty * txtpackagecost
End Sub

What's wrong

[aytee111]

In the control source of the total put the calculation : =[qty]*[cost]

in the After Update event of the both the qty and the cost, do a Me![total].Requery

[alansidman]

Try this:

Private Sub txttotal_GotFocus()
Dim txtqty As Integer
Dim txtpackagecost As Integer
txttotal = me.txtqty * me.txtpackagecost
End Sub

Need to help Access know that the fields are on the current form.

[mulefeathers]

I have tried both of these solutions and both work perfect. I am getting another error saying I can't assign a value to Me.txttotal = Null. Other than that it works.

Thanks for your help.

[mulefeathers]

Got it Thanks again