Using custom menu bar commands

[tempk]

Hi all,
I was wondering if you could use custom menu bar commands to open reports and varying the recordsource of the reports according to which command you choose. For instance, if the user wants to view a report for January, he clicks on the January menu bar button. And I do not wish to use macros as there might be many macros to use.

Was looking at it and I am able to use my own vb functions but was wondering if I could use the tag field under the customise menu bar command to specify which records to filter to?

Maybe I should just use a form with all the code behind. lol...

 

[ghudson]

I suggest you create a form, use a combo box to allow the user to select the reports to print and you can use more combo boxes to allow the user to select the criteria parameters. Make the SQL of the reports record source reference the form and the combo boxes to customize the report data output.

 

[tempk]

hey thanks for the reply...

i know u can do that but was wondering if i could use a menu bar.

this saves the users from having to open up another form. was thinking of making a generic report where the record source is determined by sql.