if value is 1,then run rpt A, ..., ...,

[nickrugado]

I want to be able to have the report that's being run be dependent on a value in a record.

i.e. if reportvalue = 1, then run reporta
if reportvalue = 2, then run reportb
if reportvalue = 3, then run reportc

I know as much as that it is a nested if then statement... can anyone help.

Thanks,
Nick

 

[grgimpy]

The code for opening a report is

DoCmd.OpenReport "Report Name", acViewPreview

Do you have a form that shows each record? How is this code run? With a command button?

Need more information to help.

 

[TheAceMan1]

How are ya nickrugado . . .

Here's an example:

[blue]   Dim [purple][b]rptName[/b][/purple] As String
   
   [purple][b]rptName[/b][/purple] = Choose(Me!ReportValue, "reportaName", _
                                    "reportbName", _
                                    "reportcName")
   DoCmd.OpenReport [purple][b]rptName[/b][/purple], acViewPreview[/blue]

[blue]Your Thoughts? . . .[/blue]

See Ya! . . . . . .

Be sure to see thread181-473997
Also faq181-2886

 

[nickrugado]

Doing well, Thanks for your answer... I have another question about the syntax and the meaning...
How does it know that 1 is to run A and 2 is to run B .... ? Is it the order in which they are listed above?

 

[Golom]

Is it the order in which they are listed above?

Yes. Check out the Choose Function

 

[TheAceMan1]

nickrugado . . .

[ol][li]From the database window hit [blue]Ctrl + G[/blue].[/li]
[li]In the immediate window type [blue]Choose[/blue]. Put the cursor on the word and hit [blue]F1[/blue][/li][/ol]
Its called [blue]context sensitive help[/blue] and is Microsofts best for calling up info. Another example:

Put the cursor or a [blue]property[/blue] or [blue]event[/blue] line. Hit [blue]F1[/blue] and read all about it!

See Ya! . . . . . .

Be sure to see thread181-473997
Also faq181-2886

 

[TheAceMan1]

nickrugado . . .

Put the cursor or a property or event line. Hit F1 and read all about it!

should be

Put the cursor [blue]on[/blue] a property or event line. Hit F1 and read all about it!

Sorry about the mess

See Ya! . . . . . .

Be sure to see thread181-473997
Also faq181-2886