VBA field Calculation

[Neilster]

Hi guys,

I want to calculate a field using VBA, I know I can add this in the Control Source =([txtApartmentCost])*0.35 to work out 35% of the Apartment Cost.

However I don't want to use the Control Source that way as it's being used on another form to run totals using DSUM.

Is there away around this?

Hope this makes sense.

 

[Minty]

You are only displaying the calculation result, not storing it? You won't be altering its value by performing a displayed calculation.

 

[Neilster]

Well I have a txtbox with Apartment Cost and below a txtbox for 35% deposit of that. ultimately you could manually enter the value, however I was wondering if there was VBA that could perform such a task and automatically fill that in. Maybe on an After Update event.

 

[Minty]

Yes in the after update of the Apartment cost me.txtDeposit = me.txtApartmentCost*0.35

 

[Neilster]

Oh yeh (-: thanks Minty should have have thought of that silly me.