Row Source

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

    Row Source

    I have 4 combo boxes on a report for the fields, City, County, IBCCP
    Agency Name, and Other Agency Name.

    The row source for City is: SELECT DISTINCTROW [Cities].[ID],
    [Cities].
    [City] FROM [Cities];
    This allows the values selected on the combo box on my main form to
    show up on my report.

    The row source for County is: SELECT DISTINCTROW [Counties].[County
    Code ID2], [Counties].[County] FROM [Counties];
    This also returns the values selected on the combo box on my main
    form
    to show up on my report.

    However, I am not successful in getting the correct row source for
    the
    fields, IBCCP Agency Name, and Other Agency Name.

    Can you help point me in the right direction?

    Thanks,

    John
    Tags: None
    • Allen Browne
      #2
      Re: Row Source

      Instead of using a combo on the report, create a a query that uses both the
      Cities and Counties table, and use that as the RecordSource for your report.

      If you run into problems wih cities that don't have a county defined, use an
      outer join. More info:
      The Query Lost My Records! (Nulls)
      at:
      Microsoft Access tips: The Query Lost My Records!
      http://allenbrowne.com/casu-02.html
      How to avoid losing records when creating a query in Microsoft Access. Describes Nulls in criteria, and outer joins.


      --
      Allen Browne - Microsoft MVP. Perth, Western Australia
      Tips for Access users - http://allenbrowne.com/tips.html
      Reply to group, rather than allenbrowne at mvps dot org.

      "zufie" <john.marruffo@ illinois.govwro te in message
      news:639f67e6-0d17-4b4b-a89c-f18c6024c1d5@y3 8g2000hsy.googl egroups.com...
      >I have 4 combo boxes on a report for the fields, City, County, IBCCP
      Agency Name, and Other Agency Name.
      >
      The row source for City is: SELECT DISTINCTROW [Cities].[ID],
      [Cities].
      [City] FROM [Cities];
      This allows the values selected on the combo box on my main form to
      show up on my report.
      >
      The row source for County is: SELECT DISTINCTROW [Counties].[County
      Code ID2], [Counties].[County] FROM [Counties];
      This also returns the values selected on the combo box on my main
      form
      to show up on my report.
      >
      However, I am not successful in getting the correct row source for
      the
      fields, IBCCP Agency Name, and Other Agency Name.
      >
      Can you help point me in the right direction?
      >
      Thanks,
      >
      John

        Comment

        Previous template Next
        Working...