how to create a macro or code to...

[Eaglezinha]

how to create a macro or code to select a different report?



I have a form with a cmd button click for preview and I put two options buttons. If the first is checked put value 1 in field table, if the second put value 2.

I have two reports and I need to select one of them if the option button is checked.

I try to do a macro and I try code but negative.

Best regards,

eaglezinha

[jya]

If it is only two options, how about this?

If Frame.value = 1 then
docmd.openreport "Report1", acViewPreview
Elseif Frame.value =2 then
docmd.openreport "Report2", acViewPreview
End If