Problems Using BeforeUpdate Event

salating · August 30th, 2005, 10:21 AM

Code:

Private Sub numChrgs_BeforeUpdate(Cancel As Integer)
    intSubscript = selectCustomer.ListIndex
    charge = charge - (Me.numChrgs.OldValue * m_900(intSubscript))
End Sub

this peice of code here pulls the amount to charge from the selected customer from the customer table and puts it in intSubscript

m_900 is a global set to currency

charge is supposed to update the textbox charge on the form to the updated price after a number has been entered into the numChrgs textbox

the problem is that unless the record has been saved, it erases the charges from the charges box only when the user enters something in a textbox and navigates to another checkbox of textbox to select or enter more info

any ideas so it wont erase charge when entering a new record without saving it first

mmcdonal · August 30th, 2005, 12:55 PM

This should be on the AfterUpdate event of numChrgs.

It also should be on the On Current event of the form.

It also should not be stored in the customer table at all. This is a calculated value and should not be stored as part of your regular data. It should be generated on your forms, reports or queries, but not stored.

HTH

mmcdonal

salating · August 30th, 2005, 01:22 PM

Code:

Private Sub numChrgs_AfterUpdate()
    intSubscript = selectCustomer.ListIndex
    charge = charge + (Me.numChrgs.Value * m_900(intSubscript))
    'The record needs to be saved after the price is adjusted, if not then an incorrect price could be calculated.
    DoCmd.RunCommand acCmdSaveRecord
End Sub

this is what i have for the AfterUpdate

i need something for the BeforeUpdate so when I enter a number in the numChrgs textbox before saving the record it will update the price in the charge textbox and not erase it

if the record is already saved it will update the price as long as its not 0

if i change it from 0 to 1 i get no change

the price is pulled from another table, the check boxes work fine, i just have a If Then Else statement controlling them, but the textbox is giving me all kinds of problems cause its not going to be -1 or 0, it can be any number

mmcdonal · September 7th, 2005, 07:29 AM

Sorry for the delay. Again, you should not have to store this number in your tables. Just generate it in forms or reports as needed. As long as the other numbers are there, you can generate any equation you need at runtime rather than storing static data.

mmcdonal