Create a Report

**bhallam** · 03-17-2011, 12:04 PM

I am attempting to create a report based on what is showinging in my Combo Box and another field populated by what is chosen in my List box. I have included my project. Any help would be appreciated!

**alansidman** · 03-17-2011, 01:08 PM

I've looked at your project and from your thread I am not entirely sure what you are trying to do. Please advise what you wish to show in your report. Give me some expected results based upon selections made in the form. This will help to understand what you want to appear. I am thinking that you need to do something similiar to what the following link shows, but I am not entirely sure.

http://www.datapigtechnologies.com/f...earchform.html

If this is not your expectation, post back with more details.

Alan

**bhallam** · 03-17-2011, 03:38 PM

alansidman,
Thank you for your reply. I check the video and it's not quite what I am looking for. My combo box allows a user to select the values to search for and will display the results in a the list box. I want to give the option to the user to select multiple items in the list box and then create a report out that shows what is in the combo box and what the user has selected in the list box. I have attached an example of what I want the report to look like after the Preview/Report button is clicked.

**alansidman** · 03-17-2011, 04:27 PM

Let me make sure I understand. You want the report to replicate what is on the input form after the user has selected the course?

**bhallam** · 03-17-2011, 05:30 PM

That is correct

**alansidman** · 03-18-2011, 03:21 PM

I believe that part of the problem stems from data normalization. You have multiple records of the same information in the same table. Additionally, you have multiple entries in the same field. You should really set up separate tables and normalize your data. Here is some information on normalization

http://forums.aspfree.com/microsoft-...es-208217.html

Having said that, I was able to get it to print to the report partially, you can select the thread but not the course list. I am not sure why you have to close the search form to edit the report or the query. I could not figure that out. That is abnormal, It also won't let you close the report or query without closing the form first. Very strange.

Oh, as an aside, from time to time while you are building a db, it tends to bloat. Run a compact and repair regularly during build to reduce bloat.