Error on Subform - value isn't valid

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

Guest

Hi,

I have been using this form for over a year now and this has never happened
before.

When I open a form I created for contacts and I have a subform embedded for
staff members names and phone numbers. When I click on this subform's
navigation button to scroll down the continuous form I get the following
error. I'm not entering or changing any information, I'm meerly scrolling.

"The value you entered isn't valid for this field. For example, you may
have entered text in a numeric field or a number that is larger than the
field size settings permits"

Can anyone tell me what this is and why it would be happening when I am not
entering data?

I have tried "compact & repair" under tools...but it is still doing this.
Do I need to delete my subform and create a new one?
 
Do you perhaps have code in the form's Current event that uses an integer,
and suddenly your values are too large for an integer? (integers can only
hold values from -32,768 to 32,767, whereas long integers can
hold -2,147,483,648 to 2,147,483,647)
 
No, none...once I click "Ok" on the error I can work fine in the subform with
no other errors unless I exit the database...then it will do it again with
just the first look up...should I delete the subform and re-create?
 
Back
Top