Err.Number value not filled in after DAO call

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

Guest

I am opening a DAO recordset, then checking the value of err.number, but the
value is not being filled in. In debug mode if I put the cursor over
err.number it doesn' even show a value.
 
At the start of your code, try

Dim errNo as long, errMsg as String

Then add

errNo = Err.Number: errMsg = Err.Description

in your code.

You can hover over the errNo and errMsg to get a value
 
Please post your code. Using Err.Number in code will always return a
value when the code is executed - even if its 0 (no error).
 
So you healed the patient's throbbing pain in the side by shooting him?
(I'm watching lost at the moment)

I would encourage you to go back and try to understand what was going on
with the Error object.
 
Back
Top