Generate report, using check boxes or query

[rumenrs]

Hi



I have 10 rows. I want for those rows to have checkboxes for every row. When I check the checkbox for 1 or 3 rows, the selected rows to be printed in report.

Or

When I run query and the result from query to be available for report with all fields from the form, because before to print the report, I want to put more info in that query (like SUM) and then print with total amount.

[pbaldy]

Would a listbox work?

http://www.baldyweb.com/multiselect.htm

If you use checkboxes, presumably in a continuous or datasheet form, it has to be bound to the table. That means multiple users can conflict with each other.

[rumenrs]

Hi, thank you for the answer.

The DB will be used always only from one person. I will try with listbox, but I need also extra fields, to put some info there before report. I mean, if we have listbox with following content:

Word
Access
Excel
PowerPoint

And if I choose Word and Access (with query maybe) to open new form with that results. Then there will be new fields and I want to put amount like:

Name | Count | Amount |Total
---------------------------
Word | 5 | 20 |100
Access | 6 | 3 |18


And those result I want to be printed in report

The main purpose of question is: How to say to the Report "Print what you see in that form"?
If I'm not clear, I will create db to show

[pbaldy]

A sample would probably help, if you're still stuck.

[rumenrs]

Ok, I will create soon a good example

[rumenrs]

Ok, I will create soon a good example

As I said, here is the example.

I found one completed DB and I want to modif it.
In this db, when I open the form "frmMultiSelect2", select some values from list box, then press the button OK, access return me only the selected values, but in table (qryMultiSelect), not in FORM.
So I want this table/query -> qryMultiSelect to be in FORM. I created in FORM, the name is: "f_qryMultiSelect" and I want this "f_qryMultiSelect" to be returned like results, after pressing the button OK (not to return "qryMultiSelect")

After that, the returned results in form f_qryMultiSelect, to be printed in Report/Printer.

Thanks MultiSelectDemonew.mdb

[pbaldy]

So use this technique:

BaldyWeb wherecondition

and use the strCriteria in the wherecondition. Will work for form and report.

[rumenrs]

So use this technique:

BaldyWeb wherecondition

and use the strCriteria in the wherecondition. Will work for form and report.

Can you make it for me in given example?

[pbaldy]

Dive in and try. What's the worst that could happen?

[rumenrs]

Dive in and try. What's the worst that could happen?

Yes, you are right. I just ask you, because I needed yesterday urgent, to show how is work
But I will try it

Sorry, for the previous post.
If my problem is solved, I will post here the example

[pbaldy]

Post back if you get stuck. I'm not abandoning you, but I'm not doing it for you either.

[rumenrs]

Hi,
I can't understand this:

DoCmd.OpenForm "SecondFormName", , , "FieldName = " & Me.ControlName
Where SecondFormName is the name of the form being opened, FieldName is the field in that form's recordsource the restriction is based on, and ControlName is the name of the control on the current form that contains the value to be shown on the second form. As you will find throughout VBA, text and date values are treated differently. For text:

DoCmd.OpenForm "SecondFormName", , , "FieldName = " & Me.ControlName


FieldName is the field in that form's recordsource the restriction is based on, and ControlName is the name of the control on the current form that contains the value to be shown on the second form.

What you mean FieldName and ControlName?
Who is that control?
and this: form's recordsource the restriction is based on

I'm using in button this above.

Access say: Run-time error 438. Object doesn't support this property or method

[pbaldy]

Did you get this figured out?

[rumenrs]

I change my mind...

I'm still stuck

[rumenrs]

All what I need is details explanation, what and where I have to use your code... and I will do it my self.
My last step is to print what I see in the form...
Please, help... or give me simple example