Button That selects report to print

[stevemccauley]

On my form I have a text box and a button. If the text box says "RED" and the button is pressed, I want the RedReport to print. If the text box says "BLUE" and the button is pressed, I want the BlueReport to print. What type of code do I have to enter into the button for this to be possible?

 

[Mario]

Something similar to this is needed under the click event procedure of your button:


if me.textbox.value = "RED" then
Reports!RedReport.print
elseif me.textbox.value = "BLUE" then
Reports!BlueReport.print
end if


Check if the print function needs argument.