using a combo box on a form in a tab to select which report to print.

[vt800c]

If the title isn't complicated enough, let me continue:

I have a 'welcome' form that has a tab control. One of the tabs is another form with a relitively simple intent: to select a report from a list in a combo box (with a OLE bitmap image of the report) and then either print or open in Preview, based on a checkbox.

The combo box recordsource is a table that has the title of the report. Also contained within each row of that table is a thumbnail image of the report and the name of the report in the Access database.

The idea is this: I select the report in the ComboBox. The form updates to show what the first page of the report is. I click a checkbox so that I can preview the report. I then click on a print button to make the report appear on the screen.



whats what I WANT to happen. I'm stuck at getting the ComboBox to update the form. I'll worry about the unicorn fart to do the printing tomorrow.

[alansidman]

Look at the tutorials on this web site for combo boxes. About 1/3 down.

http://www.datapigtechnologies.com/AccessMain.htm

Alan

[vt800c]

thats a good start, but the image of the report to be printed is a bitmapped object in the table, which causes the ComboBox to puke (I guess you can't have an image as a choice in a combo box. Would be kinda neat tho...select a report based on the picture...but I digress) So I am thinking I will have to fire some form-level event on the OnChanged event of the ComboBox. but then won't that reset the combo box to the first value and then...

I have a headache...

But I appreciate the help.

[vt800c]

Time for the Fat-Man Happy Dance! All I needed was a single line of code!

DoCmd. OpenReport me.txtReport_name, iif(chkpreview, acViewPreview, acViewReport

I guess I was overcoplicating the problem.