Report to select certain records only

[Toadums]

Hey...So I need a report that will pretty much look like this: (excuse my crappy artistic skills . but as you can se pretty much just a report that displays data in a spreadsheet like display, then underneath two combo (or select) boxes that someone can select a name or project and it will show all the records from the last week for that query)

So more or less, the person using it will be able to query the report based on those two (or maybe more...but prolly just two) fields...they can query using BOTH (paul on project number 29994) or just one (show all pauls or all project 29994)

is this not even a report at all? do I want to use a form or what ( i think a report is definitely what I need)

I havent used access in a really long time, but would I need to set up a sub form? or how might that work...I used to be pretty decent in VB, but I think I probably lost a lot of it, but can get it back somewhat easily if needed.

So what am i looking for? is it a topic i can google?

thanks!!

 

[MaZeWorX]

Personally I like to diplay this as a form then if I need to I create a report for printing. This can easily be accomplished with a continuous form and a couple of combo boxes and a subform control. Create a form add the subform with the continous form as its source. The continous forms control source is a query for my data. and I display the data based on users selection via vba requerying the form as needed. Without more detail I couldnt go into specifics regarding the code in your case.

HTH

 

[Toadums]

Unfortunately, this isnt for me, otherwise I would have no problem creating a report when ever I need it. It is for someone else at my work..and I am sure they arent computer savvy enough to......oh god, create a report in access...

I tried making a parameter query and then making a report that uses that...but what happens is the text box pops up, asks me what I would like the parameter to be...it would be perfect if the text box which pops up would just stick itself and be static within my report, exactly what I would want

thanks for the help tho! I will still give it a try

 

[rmunteanu]

Hello!
First, to get rid of the annoying borders just open the subform in design mode; open PROPERTIES sheet for "Form"; in format tab, on "Record selectors" and "Navigation buttons" choose NO. You can also set BORDER STYLE to Dialog.
Second, for the report to display only certain data, based on your selection in the subform you have to open the query that is source for the report and add reference to the combo boxes in your subform, in the CRITERIA box of the column you want to filter.
I hope this will help you.
Have a nice day!