security issue OnClose event of Report

[bhoran]

I have 2 user groups that generally are kept separate - using user-level security. They now want visibility of each others reporting.

The forms run in POp-up modal format.

On the OnClose event of the reports I currently have the user sent back to their respective forms i.e. if a sales report is closed it goes to the sales form. However, this will now have to be altered as it can be marketing or sales that have requested the report.

Is there someway to have a scenario that looks at the group the user is in then opens the correct form?

 

[Nowell]

Hi,

I think the easiest way would be to create two front ends one for sales and one for marketing.

Then you can have different functionality for each front end.

 

[bhoran]

I still don't see how that will solve my issue unless I want to duplicate all the reports or not have the control of pop-up and modal windows.

I already have 3 totally separated areas 1 for Sales, 1 for marketing and another for admin. What I currently do is automatically send the user back to the respective area when they close the report, however, it is based on the report opened i.e. sales report opened user goes back to sales area. (which was fine until recently).

I will try posting this in the coding - VBA forum.

 

[bhoran]

I found some code to do this:

Dim grp As Group
For Each grp In DBEngine.Workspaces(0).Users(CurrentUser).Groups
Select Case grp.Name
Case "Admins"
stDocName = "Main_Admin"
DoCmd.OpenForm stDocName, , , stLinkCriteria
Case "Marketing"
stDocName = "Main_MKTG"
DoCmd.OpenForm stDocName, , , stLinkCriteria
Case "Sales"
stDocName = "Main_Sales"
DoCmd.OpenForm stDocName, , , stLinkCriteria
End Select
Next grp

Cheers