Open a FORM on start and choose Subforms to open 1

[villsthearcher]

Hello,

I have 4 reports and I open these reports from 4 different coressponding forms.

What I intend to do is, Create one FORM and then have Radio buttons / check boxes in it. On selecting a Radio button/ check box, another Form is opened, through which I will open the corresponding Report.

Can anyone tell me how to do this, with a minimal use of code?



Thanks,
villsthearcher

 

[TheAceMan1]

How are ya villsthearcher . . .

If you use an [blue]Option Group[/blue] problem is easy. In the [blue]AfterUpdate[/blue] event of the Option Group, copy paste the following ([blue]you![/blue] substitute proper names in [purple]purple[/purple]):

[blue]   Dim rptName as String
   rptName = Choose(Me![purple][b]OptGrpName[/b][/purple].Value, "[purple][b]ReportName1[/b][/purple]", _
                                         "[purple][b]ReportName2[/b][/purple]", _
                                         "[purple][b]ReportName3[/b][/purple]", _
                                         "[purple][b]ReportName4[/b][/purple]")
   DoCmd.OpenReport rptName[/blue]

See Ya! . . . . . .

 

[villsthearcher]

Cool....TheAceMan1 !!

Thanks,
villsthearcher