Which Form Event

  • Thread starter Thread starter RayToddJr
  • Start date Start date
R

RayToddJr

Which event do I need to use to be able to compare an .oldvalue vs .value?

I am currently using AfterUpdate event however, the .oldvalue is always
equal to the .value?

Thanks,

Ray.
 
RayToddJr said:
Which event do I need to use to be able to compare an .oldvalue vs .value?

I am currently using AfterUpdate event however, the .oldvalue is always
equal to the .value?
Click to expand...


A bound control's .OldValue property holds the value of the control before
the record was modified. In the form's AfterUpdate event, the record has
been saved, so every control's .OldValue will be identical to its .Value.

In the form's BeforeUpdate event, or really any event that occurs after
Current and before AfterUpdate, the .OldValue may be different from the
..Value.
 

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
Cannot leave and save current record when using SetFocus 2
Cannot find Form Error 2
In a Control: Type some text, then hit a hotkey to append more text (?) 3
Select Case Statements & OldValue Property 8
Fields blanks after exit function 1
oldvalue property length limits? 4

Back
Top