Overflow Error on Form

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

Guest

Hi!

I'm getting an overflow error on a form when the recordset is 88,000 < x <
100,000
(I happen to have two identical tables with different quantities of records
at the moment)

I get the error when the form's recordset is the 100,000 record table, but
not when it is the 88,000 record table.

Anyone have any ideas why?

Yes - the form has a code module - there are a set of Fwd/Reverse command
buttons for moving between records. No variables are declared of any numeric
type.

Yes - there is a calculated control. It is in the footer and displays the
total number of records in the recordset. The error happens regardless of
the presence of this control.

I'm currently working to narrow down exactly how many records are required
to cause the error - it's something somewhere between 88,000 and 100,000.
I'll let you know what I find...
 
I've narrowed down the problem to the set of custom nav buttons I built for
the form. (I don't like the way the built-in ones look)... So now my
question is - what could cause an overflow error in a docmd.GoToRecord
statement? or do I possibly have a corrupt form/code?
 
Back
Top