"Invalid input parameter values. Check the status values for detail."

[loonytick11]

Access 2000 front end, MS SQL backend
------------
Two tables (tblA and tblB) have a one-to-one relationship. tblB's primary key is an autonumber. Nulls are allowed on all fields of both tables except the primary keys.

I made a form whose recordsource is the following SQL statement:

SELECT tblA.*, tblB.* FROM tblA INNER JOIN tblB ON tblA.Cann_Tracking_No = tblB.Tracking_No

My form has textboxes that are bound to every field from the RecordSource query, but when I try to add a new record, I get an error. "Invalid input parameter values. Check the status values for detail."

I googled this error and found a few websites (e.g.

http://www.nocomsoftware.se/p5745/files/TD41Fixes.htm)

that tell me this error is a problem with MS SQL in the WHERE clause. However, I do not have a WHERE clause in my statement, and surely JOINing two tables and using that query to populate a form is a very common task (one that should not be giving an error, for pete's sake!).

Why am I receiving this error, and is there a workaround?

 

[jbenson001]

What is your Insert statment?

 

[loonytick11]

I'm not using an INSERT statement. I'm using MS Access textbox controls bound to fields in a query.

P.S. If this post does not belong here, please direct me to the correct forum. Thank you.

 

[SQLDenis]

try here forum701
looks like you are entereing a value in the textbox which is not valid, for example 'a' for an integer column

Denis The SQL Menace
SQL blog:

http://sqlservercode.blogspot.com/

Personal Blog:

http://otherthingsnow.blogspot.com/

 

[jbenson001]

but when I try to add a new record, I get an error. "Invalid input parameter values. Check the status values for detail."

You are trying to Insert somewhere in your code...?