Report Opens without showing all of the data using menu

[burrina]

I have a monthly calendar report that opens fine when in normal design mode, i.e. not using any menu system. But when the db opens with my menu in place, i.e. File, Reports, etc... then it does not show all of the calendar? Don't know why this is! Any suggestions?
Here is the sql

SELECT Format([CalendarDate],"yyyymm") AS YrMth
FROM tblCalendar


WHERE (((Year([CalendarDate]))=[Forms]![frmAnnualCalendar]![cboYear]))
GROUP BY Format([CalendarDate],"yyyymm");

[June7]

Opening report in 'design' mode has nothing to do with displaying records and is not comparable to opening in 'report' view.

What is that query for - a combobox RowSource? Do you have code in cboYear AfterUpdate to requery YrMth combobox?

Show the query for the report RecordSource.

[burrina]

I don't know why it does that! But if I use the shift key and open the db normally it works fine.If I open and use the menu and use no other code than just open the report, it does not work. Here also is a pic of what happens when i try and open it with db in normal mode.

[June7]

What records show when query opened in datasheet?

I would have to analyse the database.

[burrina]

Did you not download the db?

[June7]

Oh, did not see the link.

Did not include forms so no menu available and had to hard code year criteria in the query.

Reports work.

[burrina]

If you open the db normally and allow the menu to open and then click on Reports from the menu and choose Monthly Calendar, you will see the resulting error. Yes, if you bypass the menu all works well??? Dont know why!

[June7]

Oops, I was expecting a menu form, not a custom toolbar. Now I see the problem. And now I see that the query is not the RecordSource for the reports.

I never built custom toolbars with Access2003 and now I am using Access2010. Looks like the toolbar is coded in the aboutEU macro. I really, really don't like macros.

I changed the Reports macro to open report in PrintPreview and the data shows.

Do you have to build mdb?

F11 key will still open the Navigation Pane. Unclick 'Use Access Special Keys' to prevent that.

[burrina]

Thanks, Macros is what I have to use until me vba skills get better. I am making progress though. Thanks for pointing out the special keys, that was a major overlook on my part. The db is now ready for market and I am inputting code to protect it, i.e. security and piracy.

Thanks again.