Really need help with VBA calculation

[Mitt1]

Okay so i'm pretty new to VBA and I've been trying for hours to get this calculation to work



I simply want to the net amount number when multiplied with the ceiling price (the prices are in the subform in the bottom right of that image) to show the total in the unit price column. I've tried loads of different thing but keep getting errors or nothing happening

Private Sub orderLineTotal_Click()
Forms![sbfrmOrderLine]![orderLineTotal] = Forms![sbfrmCeilingPrice]![ceilingPrice] * Forms![sbfrmOrderLine]![orderLineAmount]
End Sub

Can someone help me to get this to work, it's really really annoying

 

[JHB]

So far I can see, you've already ask that question once before in another thread!
Multiply threads with the same question, doesn't give you a faster response, rather the opposite.

 

[TheGhostOfRain]

Try doing this in a query.

Use the Query grid to build your calculation.

If you can't do that then post a much cut down version of your database.

 

[Mitt1]

Try doing this in a query.

Use the Query grid to build your calculation.

If you can't do that then post a much cut down version of your database.

I was told specifically I have to use VBA code though do to all my calculations

 

[sneuberg]

There's too many things that could be wrong. Without seeing the database it's difficult to provide any help.

 

[TheGhostOfRain]

I was told specifically I have to use VBA code though do to all my calculations

Are you sure?

Anyway, create an SQL in a query. Once that is working you can convert.