Oldvalue not working

  • Thread starter Thread starter Atlas
  • Start date Start date
A

Atlas

Access 2003/adp

Database bound textbox "MyField" on continuos form.

testing in the control's Beforeupdate me.MyField.oldvalue with me.MyField
they're equal even if changed.... oldvalue hold allready the new value....
 
You are probably ruinning into trouble because one of your values is null
and you can't compare to null. Try something like...

If (Nz(MyField.OldValue, 0) <> Nz(MyField.Value, 0)) Then



Rick B



Access 2003/adp

Database bound textbox "MyField" on continuos form.

testing in the control's Beforeupdate me.MyField.oldvalue with me.MyField
they're equal even if changed.... oldvalue hold allready the new value....
 
Rick B said:
You are probably ruinning into trouble because one of your values is null
and you can't compare to null. Try something like...

If (Nz(MyField.OldValue, 0) <> Nz(MyField.Value, 0)) Then



Rick B
Click to expand...
they're both the same value (two dates, both the same,niether null)
 
Back
Top