Results 1 to 2 of 2
  1. #1
    Join Date
    Feb 2005

    Unanswered: error message - not in recordset when using query

    when i try to enter records into my query this error message appears at bottom of screen and no data can be entered
    Cant add record(s); join key of “tblOrder” not in recordset
    i have attatched a screen shot of my query
    any idea why it will not work?
    thanks for any help
    Attached Thumbnails Attached Thumbnails untitled.bmp  

  2. #2
    Join Date
    Sep 2003
    Kinda self explanatory I think ... You're missing a primary key from the recordset. Figure out which one and add it to the query.
    Back to Access ... ADO is not the way to go for speed ...

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts