Syntax ^'(ctrl + ')

[Guest]

i am trying to do an update of a table with an IIF() statement where if my
criteria is true the upade copies the previous record i cannot get the synatx
right for sendkeys it may that it is not possible?

 

[John Vinson]

i am trying to do an update of a table with an IIF() statement where if my
criteria is true the upade copies the previous record i cannot get the synatx
right for sendkeys it may that it is not possible?

Well... DON'T use Sendkeys for this. It's unreliable and buggy, and
there's never a *good* reason to use it.

I would suggest either using DLookUp to find the value in the
"previous" record in the Table, if you have some criteria to identify
which is the 'previous' record (a table has no order so this may be
difficult); or, you can use a contro'ls AfterUpdate event to set that
control's Tag property to its Value, and then pull the value from the
Tag in your conditional code.

Could you explain what you're attempting to accomplish? There may be
an easier way!

John W. Vinson[MVP]