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)
 
You must log in or register to reply here.

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

Before update, after update or change event? or does it matter? 0
Going through all text/combo boxes on form, when user changes reco 3
oldvalue property length limits? 4
Select Case Statements & OldValue Property 8
Cannot leave and save current record when using SetFocus 2
Field Property (OldValue) not available in Field Object defined withDim As Field? 2
AuditTrail() Error 4
Tracking changes to a form's fields---still searching for an answe 6

Back
Top