BeforeUpdate does not fire

[maiki]

I am desperate. I make use of BeforeUpdate Sub of the form to handle data changes on the record.

The problem is that BeforeUpdate does not fire when there is a change from/to NULL value in the text field.

But when I try to use BeforeUpdate for the particular TextBox, the BeforeUpdates fires each time, even if I handle with NULLs or "" values.

I think it is a BUG in Access 97, because it does not makes sence to me.

 

[Rich]

What exactly are you trying to do?

 

[maiki]

I am trying to monitor changes of the values in the record by using BeforeUpdate Sub on the form (not particular text box). So I suppose Access would recognize that if I make a change in some of the text boxes then beforeUpdate fires.

But it does not!!! if there is no value in the textbox and I enter some value, also when I delete value in the textbox and then update the form some way, it also does not fire the BeforeUpdate function. BUT: If there is a value in the text box and I change to another value, then BeforeUpdate fires.

But when I use BeforeUpdate for that textbox (not form) it works fine....

My goal is to execute BeforeUpdate of the form, not of the textbox even with NULL or "" values.

 

[maiki]

Sorry guys, my fault.

The BeforeUpdate fires, there is a problem with handling with tha values, so its not the question of BeforeUpdate not firing itself.

 

[Rich]

Look up the Dirty function. I think it's what you require