Add an If statement behind a button on a form to determine which report to open

[louise]

Hello,
I have an "Open Report" button on a form, but would like it to select which of several forms to open, depending on the value of a field.
Presumably, this would be in a code behind "OnClick" but I haven't been able to figure out how to proceed.



I would appreciate any suggestions!
Thanks

[ItsMe]

Where are you stuck? You can create an event handler by creating a Sub Routine. This is where you place your VBA. Use the VBA editor to build your code. You can create a Sub Routine from the properties sheet. Within the Event Tab, use the ellipses for the desired Event. Then, select "Code Builder".

Your Code would look something like...

If Me.ControlName.Value = 1 then
'Perform something here
Else If Me.ControlName.Value = 2
'Perform something else
else
'Perform the default
End if

[ranman256]

I have a form frmReports where
user can pick from a list box , table tReports,
to print.

DoCmd.OpenReport lstRpt, acViewPreview

[Micron]

I agree that a slick method is to use a listbox or combobox whose record source is tied to a table of reports. It easily allows for expansion of the reports list. Just be sure to prevent multi-selecting on the control, and pass the value chosen to a little routine that decides which report to open. In that routine, I use Case Select instead of a lot IFs because it is a neat way of compartmentalizing things. You can run blocks of code within each statement. Also, if your design would permit the report to be run again after changing a date range input for example, it is best to close the report before running code to open it. Otherwise, it will usually reopen with the same data constraints. I use If CurrentProject.Allreports("rptName").IsLoaded then" to test for this and prevent an error on trying to close something that is not open.