Ugh! Can't figure this out...

  • Thread starter Thread starter Bonnie
  • Start date Start date
B

Bonnie

Hello. Using A02 on XP. Have a table with PlanNum and
CkNum as primary keys to prevent double entry. Have a
wizard standard command button to 'add new record' and
have trapped error 3022 with a custom message to say the
record already has been keyed in and to check further
elsewhere. My message box comes up fine but my trouble
comes when I try to edit that unsaved record with good
data. When I click on the button after editing my data so
it no longer violates the dup val and I get: ChkLog can't
find the field '|' referred to in your expression. If I
click the button a second time, I go to a new record. Even
if I press my Escape key a few times to remove all edits,
I get it. Can anyone shed some light on this for me? I
know it's something simple that I'm missing. Thanks
bunches!
 
Have you set the value of the field back to Null in VBA as you capture the
error?

--Catherine
 
Back
Top