If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
msaccess 2007 adp project indentity set off ? in subform
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] |
#3
|
|||
|
|||
msaccess 2007 adp project indentity set off ? in subform
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 - |
#4
|
|||
|
|||
msaccess 2007 adp project indentity set off ? in subform
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] |
Thread Tools | |
Display Modes | |
|
|