Creating Reports

[Kappucino XL]

Hi there...
I'm busy with a project where I view my information in forms. I get to choose the info I want using comboboxes. All info viewed, is in my tables, and also stored in a query. I have now, created a report from this query, but I only want to generate a report, showing only the records I chose in my form. When I click the button on this form, everything in the query is displayed, but I do not want this to happen.
I only want to generate a report, showing only the records I chose in my form.
How do I do this?Please Help :-(

[yarbrough40]

choose edit form. then delete the individual items you don't want.

[missinglinq]

Kappucino XL is not talking about deleting fields from the report but about only including selected records!

How are you "selecting" which records to include? One way would be to have a Yes/No checkbox field in your underlying table to tick to select a record, then have your report based on a query that only pulls records whose checkbox has a value of Yes.

You'll probably want to include code in the buttton that runs the report to reset the value of all checkboxes to No.

Linq ;0)>

[beacon]

It almost sounds like you want to dynamically choose the parameters for your report at any given time during data entry. You may want to check out this website, http://www.fontstuff.com/access/acctut08.htm, and see if it helps.

I usually create a form separately to run reports with parameters, but I can't see any reason why this method wouldn't work for you in the form you are currently working on. The setup is mostly in the query and then the event is placed in the code for the button on the form.

As you'll see in the link, all you'd have to do is setup the fields to accept parameters on the query and have the command button open the report. The report will then go to the query and put the parameters in place.

[NeoPa]

When you open the report, simply pass a Filter parameter to the call that matches the criteria you need.

That's about as precise as we can be without any further information. See Linq's post for questions that may help direct you to a viable solution if this is not enough for you.

[Kappucino XL]

@missinglinq
Thanx Guys!
I do however, am still battling with the code for resetting my checked checkboxes to false. I tried the SET-PROPERTY MACRO EVENT. gives me errors. In VBA, I tried setting the Value to FALSE, but I still get ERRORS.
Please help,AGAIN.
Otherwise, everything else is running smooyhly... ;-)

[NeoPa]

It's hard to help when you haven't really explained what you want help with.

You have to ask the question first. Your actual question has been answered. For more help you need to ask the question you should have asked.