reset controls ( format = currency ) value

[warmduvet]

I have a form that is populated from a combo box selection (userid) another combo box selects a value which is then multiplied by the value in another text box, the total is then displayed in a second textbox. This value along with several other fields is then inserted into a table. I want to reset the second textboxs value to zero or "" when the user selects another record to work on.

I have tried

Private Sub cmbstuid_AfterUpdate()
Me.txttotal.Value = 0
End Sub

and various other things without success

TIA

WD

 

[warmduvet]

Thank you Pat, it was that simple!!

WD