Stuart McLachlan
stuart at lexacorp.com.pg
Wed Apr 30 03:41:50 CDT 2014
I'm pretty sure that Bill meant to send this to the list, not to me directly (since he is thanking Anita) :-) -- Stuart ------- Forwarded message follows ------- Date sent: Wed, 30 Apr 2014 04:32:54 -0400 Subject: Re: [AccessD] Ribbon From: Bill Benson <bensonforums at gmail.com> To: stuart at lexacorp.com.pg Cool, will definitely get myself some practice now you've explained so well! Thanks for taking the time Stuart and Anita. On Apr 30, 2014 1:56 AM, "Stuart McLachlan" <stuart at lexacorp.com.pg> wrote: This works for me: In the Report module: Private Sub Report_Open(Cancel As Integer) Me.RibbonName = OpenArgs End Sub Then DoCmd.OpenReport "rptServicesDue", acViewPreview, , , , "MyReport" and DoCmd.OpenReport "rptServicesDue", acViewPreview, , , , "MyHide" show the relevant menus. If you are creating a form at runtime in code, I guess you could set the property just like any other property. -- Stuart --- ------- End of forwarded message -------