msaccess 2007 adp project indentity set off ? in subform

[skippyeddy]

Hi..

I have a mainform and a subform, as soon a i try to add a record. it
fails.
(invalid input parameter values.check the status values for detail.)


if i directly use the subform without the main form it works fine.

i believe the identity is set off .

thanks in advance

 

[John W. Vinson]

Hi..

I have a mainform and a subform, as soon a i try to add a record. it
fails.
(invalid input parameter values.check the status values for detail.)


if i directly use the subform without the main form it works fine.

i believe the identity is set off .

thanks in advance

Clearly you have done something wrong. But based on what you've posted, it's
impossible for anyone to even guess what might be wrong. We cannot see
anything except what you post!

Please post the actual text of the error message; open both forms in design
view and view their Recordsource properties - open the queries in SQL view and
post the SQL text here; indicate the subform's Master and Child Link Field
properties. We'll be glad to help but we need something to work with!

 

[skippyeddy]

Thanks for your response.

i have made picture

there is no vba code involved just a plain form
http://evanbeek.com/tables.gif , http://evanbeek.com/tables1.gif
,http://evanbeek.com/tables2.gif


i Hope it is clear now!

best regards

Eddy

 

[John W. Vinson]

Thanks for your response.

i have made picture

there is no vba code involved just a plain form
http://evanbeek.com/tables.gif , http://evanbeek.com/tables1.gif
,http://evanbeek.com/tables2.gif

Sorry. I won't go to an unvouched website and download binaries containing
Lord knows what.

Please, as requested, post the *TEXT* SQL view of the form's recordsource
query and the actual error message.