msaccess 2007 adp project indentity set off ? in subform

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

On Thu, 15 Apr 2010 06:55:59 -0700 (PDT), skippyeddy wrote:



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!
--

John W. Vinson [MVP]

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





On 15 apr, 18:06, John W. Vinson
wrote:
On Thu, 15 Apr 2010 06:55:59 -0700 (PDT), skippyeddy wrote:

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!
--

* * * * * * *John W. Vinson [MVP]- Tekst uit oorspronkelijk bericht niet weergeven -

- Tekst uit oorspronkelijk bericht weergeven -

On Mon, 19 Apr 2010 02:29:43 -0700 (PDT), skippyeddy wrote:

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.
--

John W. Vinson [MVP]