Results 1 to 3 of 3
  1. #1
    uaguy3005 is offline Advanced Beginner
    Windows 7 64bit Access 2013
    Join Date
    Mar 2010
    Posts
    45

    Cannont find a record in ___ with key matching fields

    I'm creating a database to track changes in our manufacturing process. I've got it setup where the issues are recorded in one table, theres a table for who can approve the change and a table for what was done to validate the parts after the change. I'm getting an error when I try to enter a record in the frm4Mchange that says "Microsoft Access Database Engine Cannon find a record in table "tblPartValidation" with key matching fields "PartValidationID" and I'm not sure why. I've attached the database here, any help on why I get this error or any other changes you see I should make, I would really appreciate it.
    Attached Files Attached Files

  2. #2
    CJ_London is offline VIP
    Windows 8 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    11,932
    your form recordsource is incomplete so not possible to comment, but it may be that you have a recordsource of two or more tables - rule is one table, one form

  3. #3
    uaguy3005 is offline Advanced Beginner
    Windows 7 64bit Access 2013
    Join Date
    Mar 2010
    Posts
    45
    Quote Originally Posted by Ajax View Post
    your form recordsource is incomplete so not possible to comment, but it may be that you have a recordsource of two or more tables - rule is one table, one form
    Yep - Turns out I had tried to put both the tblIssue and tbl4MChange on the same form. I think I've got that part corrected, on to testing again.

    Thanks for your feedback.

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

Similar Threads

  1. Replies: 3
    Last Post: 05-28-2015, 01:32 PM
  2. Replies: 25
    Last Post: 08-06-2014, 04:08 PM
  3. Replies: 8
    Last Post: 05-05-2012, 02:01 PM
  4. Replies: 3
    Last Post: 05-01-2012, 01:57 PM
  5. Replies: 1
    Last Post: 10-24-2011, 08:01 AM

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