Oldvalue not working

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....
 
R

Rick B

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....
 
A

Atlas

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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Cannot leave and save current record when using SetFocus 2
Going through all text/combo boxes on form, when user changes reco 3
Select Case Statements & OldValue Property 8
Tracking changes to a form's fields---still searching for an answe 7
Tracking changes to a form 3
Cannot set value via event 14
OldValue not available on sub forms 5
Undo or OldValue? 4

Top