Access Project is storing stuff I don't want to store!!!

[Ross1]

I have an Access 2000 data project connected to an MS SQL 2000 database.
I have code written on a Continuous Records form, (called Form1 for this explanation) to open another Single Record form (Form2) depending on which record you selected from Form1.
I had entered test data in the database and everything was working as expected. But now....
When I execute the code to open Form2, I get this error description:
"The conversion of the nvarchar value '99001154398' overflowed an int column. Max integer value was exceeded."

The trouble is my code does not try to put '99001154398', which is a primary key into an int column. In fact, this number is not even related to the records I'm working with.
It is the PK for a completely unrelated record.

Is there some way Access or SQL is storing this number in a place I may not have looked?

I step through my code and the error occurs when Form2 begins to Load.

I checked the Filter and the ServerFilter properties on Form2. I also checked to make sure there was no filter criteria on the underlying query other than what I was applying from Form1.

Please help...I can't take much more beating my head on the desk

 

[IcesMaster]

You can create a stored procedure with parameter set when opening the form 2, which is depend on the condition in Form 1.
It is more efficient then filtering in Form 2.
The error might be raised when filetring too much records

 

[cmmrfrds]

Is the data source for the Form a query that joins an nvarchar column to an int column?