Query returns incorrect results

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • zufie
    #1

    Query returns incorrect results

    I have two drop down boxes, for the fields "County" and "Category" on
    a form which when selected for the respective County and Category will
    return Agency Names of Agencies within the respective County and
    Category.

    For example, when I select Cook County and Cardiovascular disease I
    expect the query(ies) behind the form to return Names of Agencies in
    Cook County that provide services regarding Cardiovascular care.

    However, what is returned are Names of Agencies outside of the county
    and category selected.

    What is wrong? What must I fix?

    Thanks,

    John
    Tags: None
    • Fred Zuckerman
      #2
      Re: Query returns incorrect results

      I assume the dropdown boxes are, in fact, combobox controls not listbox
      controls.
      Are the properties of the combo boxes set to Limit To List = Yes?
      Does your query re-execute in the After_Update event of BOTH controls?
      Fred Zuckerman

      "zufie" <john.marruffo@ illinois.govwro te in message
      news:65aa3a09-0f65-42d3-b900-22b6b632d43f@b2 g2000prf.google groups.com...
      >I have two drop down boxes, for the fields "County" and "Category" on
      a form which when selected for the respective County and Category will
      return Agency Names of Agencies within the respective County and
      Category.
      >
      For example, when I select Cook County and Cardiovascular disease I
      expect the query(ies) behind the form to return Names of Agencies in
      Cook County that provide services regarding Cardiovascular care.
      >
      However, what is returned are Names of Agencies outside of the county
      and category selected.
      >
      What is wrong? What must I fix?
      >
      Thanks,
      >
      John

        Comment

        • Larry Linson
          #3
          Re: Query returns incorrect results

          Precise, concise questions usually get the best answers. In your case, a
          precise question would have mentioned how you use the values from the combo
          boxes. As it is, the answers to your questions would be:
          What is wrong?
          Almost certainly, your implementation.
          What must I fix?
          As you only described, vaguely, what forms, controls, and subjects, it would
          be difficult to be more specific.

          Would you care to clarify? On the assumption that you tell us what you
          have, in detail, that is going wrong, I would make a further assumption that
          someone here can offer useful suggestions.

          Larry Linson
          Microsoft Office Access MVP



          "zufie" <john.marruffo@ illinois.govwro te in message
          news:65aa3a09-0f65-42d3-b900-22b6b632d43f@b2 g2000prf.google groups.com...
          >I have two drop down boxes, for the fields "County" and "Category" on
          a form which when selected for the respective County and Category will
          return Agency Names of Agencies within the respective County and
          Category.
          >
          For example, when I select Cook County and Cardiovascular disease I
          expect the query(ies) behind the form to return Names of Agencies in
          Cook County that provide services regarding Cardiovascular care.
          >
          However, what is returned are Names of Agencies outside of the county
          and category selected.
          >
          What is wrong? What must I fix?
          >
          Thanks,
          >
          John

            Comment

            • zufie
              #4
              Re: Query returns incorrect results

              On Aug 27, 12:43 pm, "Larry Linson" <boun...@localh ost.notwrote:
              Precise, concise questions usually get the best answers.  In your case,a
              precise question would have mentioned how you use the values from the combo
              boxes.  As it is, the answers to your questions would be:
              >
               What is wrong?
              >
              Almost certainly, your implementation.
              >
               What must I fix?
              >
              As you only described, vaguely, what forms, controls, and subjects, it would
              be difficult to be more specific.
              >
              Would you care to clarify?  On the assumption that you tell us what you
              have, in detail, that is going wrong, I would make a further assumption that
              someone here can offer useful suggestions.
              >
               Larry Linson
               Microsoft Office Access MVP
              >
              "zufie" <john.marru...@ illinois.govwro te in message
              >
              news:65aa3a09-0f65-42d3-b900-22b6b632d43f@b2 g2000prf.google groups.com...
              >
              >
              >
              I have two drop down boxes, for the fields "County" and "Category" on
              a form which when selected for the respective County and Category will
              return Agency Names of Agencies within the respective County and
              Category.
              >
              For example, when I select Cook County and Cardiovascular disease I
              expect the query(ies) behind the form to return Names of Agencies in
              Cook County that provide services regarding Cardiovascular care.
              >
              However, what is returned are Names of Agencies outside of the county
              and category selected.
              >
              What is wrong? What must I fix?
              >
              Thanks,
              >
              John- Hide quoted text -
              >
              - Show quoted text -


              Sorry, here is my VBA code for all the controls (2 combo boxes and 1
              checkbox)

              John

              Option Compare Database
              Option Explicit
              Private Sub Check13_AfterUp date()
              If Me![Check13] Then
              Me![Combo3].Enabled = False
              Me![Chicago Zip].Enabled = True
              Else
              Me![Combo3].Enabled = True
              Me![Chicago Zip].Enabled = False
              End If
              End Sub
              Private Sub ToggleLink_Clic k()
              ' Me![Combo3] County
              ' Me![Combo9] Category
              Me.Requery
              If Me.NewRecord Or (Me![Check13] And IsNull(Me![Combo3]) And IsNull(Me!
              [Combo9])) Or _
              (Me![Check13] And IsNull(Me![Chicago Zip]) And
              IsNull(Me![Combo9])) Then
              Forms![Sub: Agency Lookup].DataEntry = True
              Else
              If Me![Check13] Then
              If IsNull(Me![Combo9]) Then
              Forms![Sub: Agency Lookup].RowSource = "qry Agencies by Zip"
              ElseIf IsNull(Me![Chicago Zip]) Then
              DoCmd.OpenForm "Sub: Agency Lookup by Category", , , ""
              Else
              DoCmd.OpenForm "Sub: Agency Lookup by Zip Category", , , ""
              End If
              Else
              If IsNull(Me![Combo9]) Then
              DoCmd.OpenForm "Sub: Agency Lookup by County", , , ""
              ElseIf IsNull(Me![Combo3]) Then
              DoCmd.OpenForm "Sub: Agency Lookup by Category", , , ""
              Else
              DoCmd.OpenForm "Sub: Agency Lookup by County Category", , , ""
              End If
              End If
              End If
              End Sub

                Comment

                Previous template Next
                Working...