I am new to Access2000 (5days) and have a problem with field clearing. I have looked through your postings throughout this time and have found them a great asset. I now have a problem I have not found a working solution for:
I have a form field which checks via the BeforeUpdate code to see if a number is within a certain range (and therefore valid or not)
When I find an invalid entry, I try to clear it by setting the field to Null.
When I execute the code, I get the error:
"The Macro or function set to the BeforeUpdate or ValidationRule property for this field is preventing Microsoft Access from saving data in this field"
I assume this means that the field is locked for the duration of the BeforeUpdate subroutine? How can I circumvent this?
(Using Me.Undo isn't complete enough as it doesn't guarentee field clearing)
What am I doing wrong?
I have a form field which checks via the BeforeUpdate code to see if a number is within a certain range (and therefore valid or not)
When I find an invalid entry, I try to clear it by setting the field to Null.
When I execute the code, I get the error:
"The Macro or function set to the BeforeUpdate or ValidationRule property for this field is preventing Microsoft Access from saving data in this field"
I assume this means that the field is locked for the duration of the BeforeUpdate subroutine? How can I circumvent this?
(Using Me.Undo isn't complete enough as it doesn't guarentee field clearing)
What am I doing wrong?