Show records from three combo boxes simultaneously

[Ayiramala]

Hi,
Sorry to bother you again, but just got a problem I can't solve.


On this form I have three identical Combo Boxes which show the names of the classes in our school. They are just three copies of the same combo box. What I want is this: I choose three different classes from these three boxes. Then I want a button at the bottom which when pressed, should show the records of these three classes separately. Preferably, as three columns.
I have made the Combo Boxes, but am stuck at the button to perform these actions.
How do we do it?
Any help is greatly appreciated.

[June7]

Show these records where? What do you mean by 'separately'? What do you mean by 'as columns'? Is there only one field in the table that the filter criteria will be applied to? This is applying multiple parameters to the same field. Often this is accomplished with a multi-select listbox. VBA code constructs a filter string that is applied to the form or report filter property. Review: http://allenbrowne.com/ser-50.html

[Ayiramala]

Sorry for being so vague.
I want the records to show in a report. In Microsoft Word we format a page into two or three columns. Similarly, I want the report to show the names as three columns (separately). When I press the button, it should generate the report with the names from the first combo box on the left, the second in the middle, and the third on the right.
Yes, there is only one field in the table that the filter will be applied to.
Hope that helps.

[June7]

So you pick 3 classes and want student names to list as 3 columns.

Sounds like need to do a multi-column report with group breaks on the classes. Multi-columns are set in report design view for the Detail section. Page Setup tab on ribbon.

Use code like in the referenced link to construct filter criteria and apply to the report when opening.

DoCmd.OpenReport "report name", , , strWHERE

[Ayiramala]

So you pick 3 classes and want student names to list as 3 columns.

Sounds like need to do a multi-column report with group breaks on the classes. Multi-columns are set in report design view for the Detail section. Page Setup tab on ribbon.

Use code like in the referenced link to construct filter criteria and apply to the report when opening.

DoCmd.OpenReport "report name", , , strWHERE

Thanks. I'll do as instructed and post back.

[Ayiramala]

I am very sorry to say that I couldn't get it done. tried the code in the link several times but just couldn't get it right. if I do not select any class from the list box I get a report with all the names as a single list, which includes all the classes. If I select a class from the list box a blank report is shown. Just cannot get it right..

[June7]

If you want to provide db for analysis, follow instructions at bottom of my post.

[Ayiramala]

I think after several attempts of trial and error I got it working
Thanks for your help. May I ask just one last question? Is it possible to concatenate two fields that belong to two union queries in a single field which is on a report?

[June7]

How are two union queries part of the report?

Fields that are in report RecordSource can be concatenated, regardless of how they got there.

[Ayiramala]

We have these two union queries, each with a certain field. Can we concantenate these two fields and show it in a report?

[June7]

As I said, if the fields are in the report RecordSource ...

Do these union queries have relationship - can they be joined?

Can't be more specific because I don't know your data.

[Ayiramala]

Please ignore the last post. I was able to get it done. No problems.
Thanks a lot for helping.