PDF report based on combo selected records.

[7ass00n]

Hi
Ok so I have a database that serves as product catalog. A report1 is generated based on user price filter (say to desplay all products cheaper than $100).
My question: in this report, each record should show like a combo selection box. At the end of the report there is a button to create pdf. This button should create a pdf file showing only the records which the user selected from the filtered list. (Say report1 shows 20 items, and the user selected 5 products from this list to print to pdf).
The status of combobox should not be stored in any table as it's local for that report only.
Any hints or guidlines?

[Seth Schrock]

You can't have a combobox for each record unless it is tied to a field in the report's record source and if this is the case, then values can't be changed in a report. What you should do instead is to display a form, allow the user to make their selections (again, this has to be tied to a field in a table) and then generate the report based on the selections.

[7ass00n]

Thanks for your input. I will look after it, although am not into creating a table field to tie the selection to but will so it if that's my only choice.
Any reliable code for the "on click" event to preview the report that shows only the selected records?

[Seth Schrock]

The following code will open the report:

DoCmd.OpenReport ReportName:="YourReportNameHere", View:=acViewPreview

You just need to have the record source for the report to include

"selection_field = True"

in the WHERE clause.

If you have an unbound control on either a form or report in the detail section (so that it gets duplicated for each record), then changing the value of one, changes the values for all of them. The only way then to be able to select one record and not another is to have a field for the control to be bound to. However, reports don't allow you to edit records so you are back to using a form.

You could also create a table and use a combo box to select the records that you want, but this would be even more work than my previous suggestion.

While there are usually hundreds of different ways to do any given thing, there are also limitations on what can't be done. My second paragraph tells what you can't do. It is up to you to decide what you want to do instead.

[7ass00n]

Thanks man. Appreciate your replies.
I will utilies your method and add combo selection box to base table and change statusbin the form. I guess i will have to add small code to return selection status to false after submition.

[Seth Schrock]

That would be a good idea. You can use an UPDATE query to change the values back.