Results 1 to 3 of 3
  1. #1
    jaymin is offline Advanced Beginner
    Windows Vista Access 2003
    Join Date
    Jan 2012
    Location
    gold coast Australia
    Posts
    57

    error when trying to save data entered on to a subform

    Hope someone can help, i have a form with three cascading combo boxes, this then goes to and additions only subform, you can enter the data ok but when you want to save the data an error message comes up " the microsoft jet database engine cannot find a record in table with key matching fields "IDPPE"".


    I think i could have something to do with my relationship table, as i an new to this i am not sure.
    I have included pics of the error message and relationship table also the data base.

    Click image for larger version. 

Name:	error message.JPG 
Views:	3 
Size:	13.3 KB 
ID:	7839


    Click image for larger version. 

Name:	relationships1.JPG 
Views:	3 
Size:	46.8 KB 
ID:	7838
    Attached Files Attached Files

  2. #2
    R_Badger is offline Knows a few tricks
    Windows XP Access 2003
    Join Date
    Feb 2012
    Location
    Suffolk, UK
    Posts
    262
    I have had a look and fixed it, you had a hidden field for the ID for the garment which was blank, i set it to default to text31, and now it appears to work, if you check your table you should be able to easily find the test entries i added

    The fixed file is attached below
    Attached Files Attached Files

  3. #3
    jaymin is offline Advanced Beginner
    Windows Vista Access 2003
    Join Date
    Jan 2012
    Location
    gold coast Australia
    Posts
    57
    R_Badger,
    Thank you for your help.
    Peter

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 3
    Last Post: 12-01-2011, 06:51 AM
  2. Replies: 13
    Last Post: 09-14-2011, 07:19 AM
  3. locking data in subform after record save
    By Nixx1401 in forum Forms
    Replies: 24
    Last Post: 05-31-2011, 01:48 PM
  4. Replies: 1
    Last Post: 11-25-2010, 11:00 AM
  5. Replies: 4
    Last Post: 05-17-2010, 05:32 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums