I have 3 (as of right now) different reports that need to be run from the same data in a table. These reports are very similar but vary based on one value in the table. Field "Type" can have one of 3 values: "Flat Oval", "Round", or "Rectangular". I have a form with a button to run a report, but I need it to choose which report to run based on this value.

I thought about using an IIf statement but I don't know if I should put it in the onclick of the button or how to structure it.

Thanks in advance for any help.

let me get this straight you have a certain condition that is available on the form and based on that condition u would like to open a specific report try this. suppose the condition is in a textbo1.

if me.textbox1=Condition1 then
docmd.openReport ReportName1
elseif me.textbox1=Comdition2 then
docmd.openreport ReportName2
else
docmd.openreport ReportName3
end if

it is not clear whether you want to open the reports view particular reports if so you have to add a criteria if u need 2 do that please let me know. if this solves your problrm please mark this thread as solved

That wasn't exactly what I needed but it did get me on track enough to figure the rest out. Thank you very much, the exact code I used was

If Me.Type = "Round" Then
[Round].Visible = True
[Rectangular].Visible = False
[Flat Oval].Visible = False
ElseIf Me.Type = "Rectangular" Then
[Round].Visible = False
[Rectangular].Visible = True
[Flat Oval].Visible = False
ElseIf Me.Type = "Flat Oval" Then
[Round].Visible = False
[Rectangular].Visible = False
[Flat Oval].Visible = True
Else
[Round].Visible = False
[Rectangular].Visible = False
[Flat Oval].Visible = False
End If

P.S. I will try to mark it solved but am not 100% sure how to