Simple calculation

[Mitt1]

I'm kinda new to VBA and all I want to do is multiply the quantity by the agreed price and get the total to appear in the total box below the sub form.

 

[Ranman256]

In your query,(for the sub form), put in the calc:
Amt: Cost* qty

 

[Mitt1]

In your query,(for the sub form), put in the calc:
Amt: Cost* qty

Thanks, but i'm still confused

 

[stopher]

Thanks, but i'm still confused

You don't need VBA to do this. Your form will be based on a query or table. In the form's property sheet undert the "data" tab you will see the "record source". If you click the three dots at the end you will either be shown the query window or asked if you want to create a query (which you do). Once you are in the query window you can add the text that Ranman suggested:

Amt: Cost* qty

The above text goes in a new column in the query designer in the "Field:" row. This is essentially giving you a new calculated field called Amt. When you save the query, this field will be available to use in the form.

hth

 

[stopher]

Here's a fuller description of how to add calculated fields to queries
http://www.fontstuff.com/access/acctut02.htm