Error not displaying

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a form dependent on a query.
Info_A is set in the table as the primary key with no duplicates.

I use a query to find the correct record in a table and change the value in
Info_A

Field Info_A does not allow duplicates therefore an error should occur when
I close my input form. I even places a Docmd.Save into the exit portion of
the Info_A field to see if that would make the error come up but it does not.

I also tried checking the err.number and err.description right after the
Docmd.save entry however I get nothing.

I tried using a Dim ErrorNumber as String which works ok and the error
handling built by the wizard then works however I get a Type Missmatch Error
and the End and Debug screen. I removed this code however.

How do I get the error process to work properly what am I doing wrong.

Thanks ahead of time....
 
I think the problem is you're looking at the Err Object, which, IIRC, is VBA
only. A VBA error has probably not occurred. You may want to try looking
at the Error collection, which returns ADO or DAO errors.

HTH;

Amy
 
Back
Top