Results 1 to 2 of 2
  1. #1
    Join Date
    May 2012

    Unanswered: Query stops working when I add second table

    I am new to access and databases in general but I am working my way through. I built a form that ran a query from the selection within the combo box on the form. It works perfectly until I add data to the query from a second table. The only data I need from the second table is a link to a scanned document that doesn't need to be sorted but just needs to be visible on the query results.

    As soon as I show the table in the query design window, it stops working and doesn't find any results. I don't even have to add the field from the second table for it to stop working. Why would this be?

  2. #2
    Join Date
    Nov 2004
    out on a limb
    Provided Answers: 59
    check the join type
    right click the line line linking the tables and make certain you select the right type of join.
    I'd rather be riding on the Tiger 800 or the Norton

Tags for this Thread

Posting Permissions

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