Results 1 to 4 of 4
  1. #1
    Join Date
    Jan 2004
    Location
    Slovakia
    Posts
    32

    Unanswered: union query with criterias as a recordsource

    In the attached database (only sample) I am using an union query as a recordsource for my form. Because the union query has criterias in his "subqueries" (these are date values from my form), no records are displaying on my form... Why?
    Attached Files Attached Files
    (sz)Tomi

  2. #2
    Join Date
    Oct 2003
    Location
    Roanoke, Va
    Posts
    445

    Re: union query with criterias as a recordsource

    Originally posted by sztomi
    In the attached database (only sample) I am using an union query as a recordsource for my form. Because the union query has criterias in his "subqueries" (these are date values from my form), no records are displaying on my form... Why?
    You didn't have the recordsource set to the union query in what I just looked at. You had it set to a select query called q.
    Gregg


    DAO, ADO, SQL, Automation and anything else I can pick up.

  3. #3
    Join Date
    Jan 2004
    Location
    Slovakia
    Posts
    32
    my mistake, the correct mdb is attached
    Attached Files Attached Files
    (sz)Tomi

  4. #4
    Join Date
    Oct 2003
    Location
    Roanoke, Va
    Posts
    445

    Smile

    Originally posted by sztomi
    my mistake, the correct mdb is attached
    Your subqueries are looking at the same form that the Union query is the recordsource for. It's kind of a circular reference. The subqueries can't get their data because the recordsource for the form that feeds them depends on them. Try to get the values that you need for either the form or the subqueries in another way.
    Gregg


    DAO, ADO, SQL, Automation and anything else I can pick up.

Posting Permissions

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