Edit Data and Recalculate WITHIN THE FORM ONLY

[AusStiffler]

Hi,

I have created a form populated from an underlying database. I have an unbound text box on the form [totalCostPrice] that calculates data from 2 other bound text boxes. eg: [unitprice]*[quantity]. I need to be able to change the unit price on the form only and recalculate the result WITHIN THE FORM ONLY and not the underlying database. I keep getting the error ODBC --call failed. []MYOB ODBC] functionality not supported. (#0). It seems to be requerying the underlying database even if I provide an event procedure me.recalc on lost focus. Can you please provide a solution asap?

[slave138]

I would add an extra (unbound) field for the editable unit price and then hide the current one. Use OnCurrent to set the value of the unbound field to match the hidden one and set the calculation to use the unbound field.

[AusStiffler]

Thanks Slave138,

Seems to work however when I use the following:

Private Sub Form_Current()
Me.UnitPriceUpdated = Me.TaxInclusiveUnitPrice

End Sub

The result generated by (taxInclusiveUnitPrice) to the unbound textbox (UnitPriceUpdated) is filled with the value from the top row only.

eg; [TaxInclusiveUnitPrice] [UnitPriceUpdated]
Row 1 = $7:00 $7:00
Row 2 = $15:00 $7:00
Row 3 = $27.50 $7.00
Etc ...

I am obviously overlooking something ...do you have a possible solution?

Cheers!

[slave138]

I need a little more info about the form you are using. What kind of a layout are you using? A screen shot of the form or a sample DB would help.