How do I select a record from a Listbox and activate the OpenReport method? (1 Viewer)

[countgallo]

I'm attempting the following in MS-Access 97

I have a 'Form' Named FrmReportSelection

I'd like to create an option group of '6' buttons representing MS-Access
Report 'Categories'. When the user selects an option from the Category
(option group) the contents of a listbox are filtered to display which
reports are in that category. However, I'd then like for the user to select
an option from the displayed listbox and then:

A) display a 'Description' for the selected Report in a seperate List/Text
box
B) with the selected report 'Trigger an event' from a Button that Opens the
selected report.

I've managed so far to Limit the contents of the Listbox using the example
given in the Access 'Solutions.mdb' sample database:
"Limit the contents of a list based on the value selected in an option
group".
But the example falls short of doing anything with the contents of the list!

DoCmd.OpenReport reportname[, view][, filtername][, wherecondition]

I think its the wherecondition part I need to link to the recordID in the list?


I'm sure there's an example somewhere of a Form that uses option buttons to
filter a list and then trigger an event when a record in the list is
double-clicked or an OK button is pressed.

can anyone help?

Thanks In Advance

 

[Rich]

Use the on click or double click event of the list box.