Listbox selection to create report

[mmjr103]

Good evening everyone,

I am going to try this again. I am very new to access, and really green when it comes to using the program so I am learn as I go. I started to create a database for work, and never thought that it would get this involved. The pressure is on at work to complete the project. Almost like open mouth and insert foot, rather just with this DB. Now that I have the tables, forms, and some reports create I need to be able to put it all together.

I have a series of tables(8) that in some way are all linked together through 'Indiv ID' we will call it.

I then created a form with several listboxes to select a record 'County' and then a command button to execute the report. How the heck, or what am I doing wrong here. I also have where you have to select from 2 list boxes to filter a different report.

Please help steer me in a direction that I can accomplish these tasks. Thanks, and any help is greatly appreciated. I can exchange discussion via email if that would be better.

Thanks
MMJr

 

[cpberg1]

Do you have a specific question or problem? What is the database not doing that you think it should? What have you done to remedy that block? More specifics needed! Welcome! Access is not easy to learn from scratch but a step at a time you'll get there

 

[mmjr103]

I have created a form called 'Reports Form'. Within the form are several list boxes. There are like 'County', 'Level' and 'Individuals' list boxes. I want to be able to select something from one of the list boxes and click on a command button to open a report and generate report based on selection in list box. On this reports form there are multiple reports that need to be generated, each having a list box and command button depending on which report you want. I am not sure how to build expression, what al the little symbols mean.

If you have a email, I can possibly send you a screen shot so that you can see what I am refering to.

Thanks

 

[cpberg1]

you can post your pictures on here. read
http://www.access-programmers.co.uk/forums/showthread.php?t=223479
for instructions.

Do you have a query built yet for the reports recordsource?

In the query that will gather the information for your report you'll need to set the listbox or combobox on your [report form] as the criteria for the appropriate column.

Check out Bob's site for excellent example
http://www.btabdevelopment.com/ts/cbo4qry

Also you really should start using CamelCase for your access objects, controls, ect. Access does not play nicely with spaces in the object name fields. It will cause you all kinds of problems later on.

Using camel case this would become this
UsingCamelCaseThisWouldBecomeThis

Post back with progress and/or questions!