Retrieving data from combo and embedding in a report

Posted on 2011-05-06
Medium Priority
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
  • 2
  • 2
LVL 74

Accepted Solution

Jeffrey Coachman earned 600 total points
ID: 35710725
Set the control source to something like this:
=[Forms]![Form test]![combo1].Column(0) & " " & [Forms]![Form test]![combo1].Column(1)

Author Comment

ID: 35711610

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

Author Closing Comment

ID: 35718338
it works a treat
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 35721103

Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Microsoft has changed the look and feel of Azure AD and Microsoft account sign-in pages so that you will have a more unified look and feel when moving between the two interfaces.
In a use case, a user needs to close an opened report by simply pressing the Escape (Esc) key. This can be done by adding macro code in Report_KeyPress or Report_KeyDown event.
The viewer will learn how to  create a slide that will launch other presentations in Microsoft PowerPoint. In the finished slide, each item launches a new PowerPoint presentation and when each is finished it automatically comes back to this slide: …
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…

809 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