salating
08-29-2005, 12:50 PM
I have a text box that the user enters a number in. It pulls the price from another table and updates the variable "charge" and shows the updated price in a textbox on the form.
problem is when the user creates a new record and puts a number in the textbox, it erases the charge from the textbox that displays the updated charge.
here is the code
Private Sub numEdu_BeforeUpdate(Cancel As Integer)
intSubscript = selectCustomer.ListIndex
charge = charge - (Me.numEdu.OldValue * m_educ(intSubscript))
End Sub
numEdu is assigned to the input textbox
problem is when the user creates a new record and puts a number in the textbox, it erases the charge from the textbox that displays the updated charge.
here is the code
Private Sub numEdu_BeforeUpdate(Cancel As Integer)
intSubscript = selectCustomer.ListIndex
charge = charge - (Me.numEdu.OldValue * m_educ(intSubscript))
End Sub
numEdu is assigned to the input textbox