Strange Report Coding/Security conflict

J

JString

Greetings all...

I have a report with a subform window in it. This code is placed in the on
open event:

Me.RecordSource = myfilters.GetFilter(getMainForm(getSource(Me.OpenArgs)))
Me.subwindow.SourceObject = "Form." & Me.OpenArgs
DoCmd.Maximize

When the report opens, it should set the subwindow to a form that is set in
the report's openargs property, and it does for the most part. It works fine
when I'm logged in as an administrator but if I try it while logged in under
a normal user account I get the following error:

Error 2614

You don't have permission to insert this form into another form.

I checked the security settings and I double checked to make sure normal
users had all permissions set to this particular report.

Many thanks in adance if anyone can help.
 
C

Cheese_whiz

Hi JString,

Just from the error message it appears the permissions problem is in the
subform, not the report. Maybe you should try manipulating the permissions
in the subform.

CW
 
J

JString

You were correct.

Turns out that the subform's "Read Design" permission had to be enabled.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top