hosamuk

Hi everyone i have a problem with microsoft access, where i am trying to write a program for currency exchange i.e. USD to EURO etc... i have written a piece of code in VB but every time i run the access application form and i change the currency from GBP to USD and then enter the amount in pounds in Price_Each text box i get an error message. The code is bellow:

Private Sub Price_Each_BeforeUpdate(Cancel As Integer)
If Form_Purchase.ComboCurrency <> "GBP" Then
price = Price_Each.Text * Form_Purchase.Rate
End If
Price_Each.Text = price
End Sub

The error message i get is:
"The macro or the function set to the BeforeUpdate or ValidationRule property for this field is preventing Cost Control System from saving the data in the field"

can anyone help me in solving this problem

i'll be looking forward for your replies..

thanks in advance

kinds regard

sam