Hi,
I have a form and when the user clicks on the save record command button
it calls the Form_BeforeUpdate event function. Also, the Form_BeforeUpdate
shall be called when the user presses the close button (top X button).
The function checks the values entered into textboxes and comboboxes etc
are valid. If they are deemed to be valid the data is written to to a number
of tables using SQL statements INSERT/UPDATE depending on whether it is
a new record or he/she is updating a previous record. However, as it reaches
the first Insert statement the system gives me the following error message:
"Run-Time error 2115" The macro or function set to the BeforeUpdate or
ValidationRule property for the fields is preventing Microsoft Access
from saving the data in the Field.
I'm not sure what I'm doing wrong as the SQL statement seems correct and the use of Form_BeforeUpdate seems to follow examples I have seen on the net.
I have checked the net, but don't understand thier solutions.
Any help would be much appreciated!
Thanks
I have a form and when the user clicks on the save record command button
it calls the Form_BeforeUpdate event function. Also, the Form_BeforeUpdate
shall be called when the user presses the close button (top X button).
The function checks the values entered into textboxes and comboboxes etc
are valid. If they are deemed to be valid the data is written to to a number
of tables using SQL statements INSERT/UPDATE depending on whether it is
a new record or he/she is updating a previous record. However, as it reaches
the first Insert statement the system gives me the following error message:
"Run-Time error 2115" The macro or function set to the BeforeUpdate or
ValidationRule property for the fields is preventing Microsoft Access
from saving the data in the Field.
I'm not sure what I'm doing wrong as the SQL statement seems correct and the use of Form_BeforeUpdate seems to follow examples I have seen on the net.
I have checked the net, but don't understand thier solutions.
Any help would be much appreciated!
Thanks