Opens forms AND Reports from same list box?

[cooper]

Hi,

is it possible to open FORMS AND REPORTS from the same list box?

i know I can open forms by bounding the column, but can I open both forms and reports?

thanks!

[June7]

Why do you need to open form and report? What do you mean by 'open forms by bounding the column'?

Certainly doable. How are you populating the listbox RowSource? Use VBA code to open whatever you want based on listbox selection.

Select Case Me.listbox
Case "this value1"
DoCmd.OpenForm "form name"
DoCmd.OpenReport "report name"
Case "this value2"
...

[cooper]

My Weekly reports are infact Pivot charts made on a form! and my quarterly reports are normal reports that is why!!

"this value 1" - would this be the actual report/form name?

[cooper]

Why do you need to open form and report? What do you mean by 'open forms by bounding the column'?

Certainly doable. How are you populating the listbox RowSource? Use VBA code to open whatever you want based on listbox selection.

Select Case Me.listbox
Case "this value1"
DoCmd.OpenForm "form name"
DoCmd.OpenReport "report name"
Case "this value2"
...

GENIUS it works!! thanks for helping out again June 7.