Holly_Associated
Registered User.
- Local time
- Today, 18:43
- Joined
- Mar 21, 2013
- Messages
- 53
Hi experts!
Today I have come across a little problem which I think I understand but am not sure how to approach.
I have a report rptAllCSCS which is based on a query qryCSCS2 [ Thanks Nigel
! ]
This has a filter which is based on the Status field, [Status]="Current"
The filter works fine; I can open the query in datasheet and press the 'Toggle Filter' button in the ribbon. I have put two buttons on the report header which are attached to macros 'ApplyFilter' and 'RemoveFilterSort', all working fine when I open the report as standalone.
The only problem I am getting is when I open the report via my Navigation Form frmMain: It has two rows of tabs across the top. One of the top tabs is 'Reports' and when selected the row of tabs below shows different reports (viewable in report view for my users with some snazzy conditional formatting). I have a button on the header to open the report in print preview which works as expected. I'm just not sure how to get the filter buttons to work for my users? I understand it is because frmMain is not attached to a record source, so how do I reference it? All of the tabs are called 'NavigationSubform' and it doesn't seem to recognise the original query which I based the report on?
I understand I can put a button in the header to open the report as standalone and then the filter buttons will work but it seems a bit... messy.
Any ideas much appreciated!
Today I have come across a little problem which I think I understand but am not sure how to approach.
I have a report rptAllCSCS which is based on a query qryCSCS2 [ Thanks Nigel
! ] This has a filter which is based on the Status field, [Status]="Current"
The filter works fine; I can open the query in datasheet and press the 'Toggle Filter' button in the ribbon. I have put two buttons on the report header which are attached to macros 'ApplyFilter' and 'RemoveFilterSort', all working fine when I open the report as standalone.
The only problem I am getting is when I open the report via my Navigation Form frmMain: It has two rows of tabs across the top. One of the top tabs is 'Reports' and when selected the row of tabs below shows different reports (viewable in report view for my users with some snazzy conditional formatting). I have a button on the header to open the report in print preview which works as expected. I'm just not sure how to get the filter buttons to work for my users? I understand it is because frmMain is not attached to a record source, so how do I reference it? All of the tabs are called 'NavigationSubform' and it doesn't seem to recognise the original query which I based the report on?
I understand I can put a button in the header to open the report as standalone and then the filter buttons will work but it seems a bit... messy.
Any ideas much appreciated!
