Retrieving data from combo and embedding in a report

Posted on 2011-05-06
Last Modified: 2012-05-11
Hi all,

I have a combo called "combo1" in form called "test". The items that appear in the combo are picks up two fields from  table z,

i.e. field x and field y from Table z

The row source looks something like this:-

Select [x],[y] from [table z] order by [z] ASC;

I then have a report which shows this slected item; the text entry in the report looks like:

=[Forms]![Form test]!combo1]

My problem is that only that [x] appears in the report but not [y]?

Hope this is clear!!

Question by:PipMic
    LVL 74

    Accepted Solution

    Set the control source to something like this:
    =[Forms]![Form test]![combo1].Column(0) & " " & [Forms]![Form test]![combo1].Column(1)

    Author Comment


    Will try and get back to you....simplicity!!

    Author Closing Comment

    it works a treat
    LVL 74

    Expert Comment

    by:Jeffrey Coachman

    Featured Post

    How your wiki can always stay up-to-date

    Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
    - Increase transparency
    - Onboard new hires faster
    - Access from mobile/offline

    Join & Write a Comment

    Article by: Leon
    Software Metering within our group of companies has always been an afterthought until auditing of software and licensing became a pain point. Orchestrator and SCCM metering gave us the answer and it was an exciting process.
    My experience with Windows 10 over a one year period and suggestions for smooth operation
    In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …
    The view will learn how to download and install SIMTOOLS and FORMLIST into Excel, how to use SIMTOOLS to generate a Monte Carlo simulation of 30 sales calls, and how to calculate the conditional probability based on the results of the Monte Carlo …

    754 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    17 Experts available now in Live!

    Get 1:1 Help Now