option group for a report

[misscrf]

I have an option group that has 4 options. The options are account 1, 2, 3, or all accounts.

I want to have the report run based on the choice the user selects. Why is this so hard? I can't seem to find how I evaluate the option group in the account fields criteria in the reports control source.

Can anyone please help?

 

[misscrf]

why is no one answering my post? Im gonna cry!

 

[ansentry]

misscrf,


I would put 3 command buttons at the bottom of the option group, Preview, Print and Cancel. Behind the Preview and Print I would use "Select Case"

Have a look at the Northwind sample , Form(Sales Report Dialog) code behind the button Preview.

If you can't work it out then post back with a cut down sample of you db and I will have a look at it.


Regards,